[postgis-users] PostgreSQL 8.3 GiST Bug

[Paragon Corporation]

I noticed they also have this patch in there that may solve some of those
frustrating IN(....) inefficiencies

Improve optimization of expression IN (expression-list) queries (Tom, per an
idea from Robert Haas) 

Cases in which there are query variables on the right-hand side had been
handled less efficiently in 8.2.x and 8.3.x than in prior versions. The fix
restores 8.1 behavior for such cases.  

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Wednesday, November 12, 2008 8:10 PM
To: PostGIS Users Discussion
Subject: [postgis-users] PostgreSQL 8.3 GiST Bug

Important information for PostGIS users! If you are on the PostgreSQL
8.3 series, upgrade to 8.3.5 as soon as possible, as earlier releases
contain a GiST index bug which may cause data to occasionally not show up in
spatially indexed searches.

This bug will only affect tables that have had records deleted and updated
and new data inserted, so people using PostGIS in a primarily read-only
manner won't see it, but folks with changeable data may run into it.

http://blog.cleverelephant.ca/2008/11/postgresql-835-important-upgrade.html
http://www.postgresql.org/docs/8.3/static/release-8-3-5.html

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