| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "Robert W(dot) Burgholzer" <rburghol(at)vt(dot)edu> |
| Cc: | PostGIS Development Discussion <postgis-devel(at)postgis(dot)refractions(dot)net>, Mark Cave-Ayland <mark(dot)cave-ayland(at)siriusit(dot)co(dot)uk>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break |
| Date: | 2008-12-05 16:19:14 |
| Message-ID: | 87fxl2vblp.fsf@oxford.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Robert W. Burgholzer" <rburghol(at)vt(dot)edu> writes:
> FWIW,
> I have experienced some oddities in performing SELECT statements after
> restarting on an 8.2 system, whereby I occasionally would get a ton of
> duplicate records when I would do a select statement (my assumption is that
> they are deleted tuples being returned). If I executed the same select
> statement again, I would get the correct number of records.
Sounds like this item fixed in 8.2.10:
# Fix possible duplicate output of tuples during a GiST index scan (Teodor)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2008-12-05 16:58:03 | Re: Simple postgresql.conf wizard |
| Previous Message | Kurt Harriman | 2008-12-05 15:45:04 | Re: Mostly Harmless: Welcoming our C++ friends |