[OSM-dev] Is there a way to use simple schema without hstore
andreaskalsch at gmx.de
Fri Nov 19 10:33:17 GMT 2010
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:
> 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.
More information about the dev