[OSM-dev] Is there a way to use simple schema without hstore

[Andreas Kalsch]

I agree - my approach is the playground approach: At first, keep it simple. For your purpose it is 
correct to split the table. What about a partial index over 1 table? This is possible with Postgres.

Am 19.11.10 11:03, schrieb Sven Geggus:
> Andreas Kalsch<andreaskalsch at gmx.de>  wrote:
>
>> Example for unnessessary complex schema design:
>> http://wiki.openstreetmap.org/wiki/DE:HowTo_minutely_hstore
> You are welcome to design a better database scheme suitable for rendering :)
>
> osm2pgsql output is evolution _not_ design.
>
> Using a join in every single SQL request is not an Option in this case at
> least performancewise.
>
>> Probably I am wrong ... yes I know that you can index hstore with a GIST.
> GIN
>
> Sven
>