Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break

From: Mark Cave-Ayland <mark(dot)cave-ayland(at)siriusit(dot)co(dot)uk>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: PostGIS Development Discussion <postgis-devel(at)postgis(dot)refractions(dot)net>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break
Date: 2008-12-05 15:09:42
Message-ID: 49394436.5090304@siriusit.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gregory Stark wrote:

> Uhm. That rather sucks. I was able to reproduce it too.
>
> It seems to happen after I pause for a bit, and not when I run the script in
> fast succession.

Thanks for the verification Greg. I'm wondering if the GiST part is a
red herring, and in fact it is related to some bizarre interaction
between CLUSTER/VACUUM/autovacuum?

ATB,

Mark.

--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert W. Burgholzer 2008-12-05 15:25:55 Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break
Previous Message Gregory Stark 2008-12-05 15:01:51 Re: Simple postgresql.conf wizard