[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