BUG #4491: regression in gist indexes

From: "Jeff Frost" <jeff(at)frostconsultingllc(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4491: regression in gist indexes
Date: 2008-10-22 22:11:47
Message-ID: 200810222211.m9MMBlmJ052718@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4491
Logged by: Jeff Frost
Email address: jeff(at)frostconsultingllc(dot)com
PostgreSQL version: 8.3.4
Operating system: Fedora 9/Gentoo/Mac OS X
Description: regression in gist indexes
Details:

It seems that 8.3.4 has a regression in the updating of gist indexes. After
updating an indexed column in a row with a postgis gist index, the row is no
longer found in an index scan. I have verified that this works on 8.2.7,
8.3.0, 8.3.1 and 8.3.3 but not 8.3.4.
Verified this is a problem on Fedora 9/Gentoo/Mac OS X.

You can see the test case here:

https://gist.github.com/d6c9b183196717d73b6a

Interestingly, the first index scan after the update does find the row, but
subsequent scans do not.

Here you can see it working on 8.3.0:

https://gist.github.com/d0dbbf29606822b8ceb9

You can grab the test table data dump here:

http://www.frostconsultingllc.com/coordinate_test.dmp

Please contact me if there's anything else you need to reproduce the bug.
Note that if you're using the coordinate_test data, you'll have to set
enable_seqscan = 0 to force an index scan as the table only contains 100
rows.

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Frost 2008-10-22 22:54:00 BUG #4491: regression in gist indexes
Previous Message David E. Wheeler 2008-10-22 19:33:59 ERROR: cache lookup failed for function 0