Postgres Pro
Downloads
Home   >   mailing lists

Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break - Mailing list pgsql-hackers

From Mark Cave-Ayland
Subject Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break
Date
Msg-id 49394436.5090304@siriusit.co.uk
Whole thread Raw
In response to Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break  ("Robert W. Burgholzer" <rburghol@vt.edu>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Simple postgresql.conf wizard
Next
From: "Kevin Grittner"
Date:
Subject: Re: Simple postgresql.conf wizard