[postgis-users] Performance of seperate spatial data

[Ries van Twisk]

Eric,

you can speed up you queries if you use a different tablespace  for your 
indexes and your table.
Ofcourse you need to make sure that each tablespace sits on a different 
phisical harddisk
(I have seen people that put it on a different partition thought that 
was the way...).

Unless the number of attributes is uge, I don't think you will gain much 
by seperating spatial data from attribute data.

Ries

> Hello list,
>
> would there be any performance gain if I were to put all the 
> spatial/geometry data in one table and the other attributes [numbers, 
> text ..] in a seperate table? If so, what would be the correct way to 
> link the two tables? A correlating index on both tables?
>
> All my queries will actually need to access both the attributes table 
> and the spatial table if I were to split them up.
>
> Is there a good test to determine the performace bewtween having 2 
> tables and just 1 table I can run to check it out?
>
> Regards
> Eric Lam
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



-- 
Ries van Twisk
Freelance Typo3 Developer
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk