[postgis-users] query optimization

Dylan Keon keon at nacse.org
Tue Dec 14 16:19:27 PST 2004


On 12/14/2004 04:13 PM, Paul Ramsey wrote:
> Oh, one other silver bullet:
> 
> If you upgrade to the CVS head (soon to be 1.0RC1), you can use the 
> lightweight geometries. Since your data is points, you will get a *huge* 
> boost in terms of storage efficiency. (about 4:1 for points I think). A 
> smaller on-disk representation means less disk hits to pull the same 
> amount of data through the system.
> 
> Try that!


I will!  Thanks for the tips.

--Dylan



More information about the postgis-users mailing list