[postgis-users] Documenting performance tip

[strk at refractions.net]

Docs are in CVS.
--strk;

On Fri, Feb 04, 2005 at 02:40:23PM +0100, Markus Schaber wrote:
> Hi, Strk,
> 
> strk at refractions.net schrieb:
> 
> > No, the && query won't use Z or M, question was wheter a ZM box polygon
> > would be TOASTED... if yes the query should be:
> >
> > set bbox = Envelope(force_2d(geom_column));
> 
> Yes, that's right. We do not need to save Z and M in the bbox column. So
>  feel free to update my text with your query.
> 
> >>My personal opinion: The whole thing is just only a workaround for a
> >>hopefully soon-to-be fixed query planner problem that bites in a rather
> >>strange corner case. I do not think that we should spend too much energy
> >>polishing it.
> >
> > Don't all postgresql version *suffer* from this ?
> > If yes I think it's worth giving a polite tip about it.
> 
> Yes, they do. And this is the reason why I wrote the text for inclusion
> into the docs.
> 
> I wanted to say that we should not spend too much energy into making the
> workarounds beautiful and aesthetic.
> 
> 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