[postgis-users] Documenting performance tip

[Markus Schaber]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050204/33ea562e/attachment.pgp>