[postgis-users] Documenting performance tip

[strk at refractions.net]

On Thu, Feb 03, 2005 at 11:45:55AM +0100, Markus Schaber wrote:
> Hi, Strk,
> 
> Markus Schaber schrieb:
> 
> > As a small workaround, I could imagine to add a small additional column
> > in the table that contains the geometry's bbox, and which I use the &&
> > operator against. This should avoid touching the TOAST for the skipped rows.
> 
> Maybe we could add this hint somewhere in the documentation, for small
> tables (few columns, few rows) with large geometries.
> 
> Should I try to write something up, or are there more skilled writers
> around?

Beside writers skills this needs full understanding of the problem.
If you can document the problem and the tip it would be helpful.
--strk;

> 
> Markus
> 
> --
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 zürich
> phone +41-43-888 62 52 | fax +41-43-888 62 53
> mailto:schabios at logi-track.com | www.logi-track.com



> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users