From: | "Paul Ramsey" <pramsey(at)cleverelephant(dot)ca> |
---|---|
To: | "Gregory Stark" <stark(at)enterprisedb(dot)com> |
Cc: | "Mark Cave-Ayland" <mark(dot)cave-ayland(at)siriusit(dot)co(dot)uk>, "PostGIS Development Discussion" <postgis-devel(at)postgis(dot)refractions(dot)net>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: CLUSTER in 8.3.5 on GIST indexes loses all rows |
Date: | 2008-12-05 20:15:06 |
Message-ID: | 30fe546d0812051215l113c640bkc3c8b0af709236ce@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
FYI, this is not limited to PostGIS GIST, it appears to be all GIST
(gid is an integer column and I have loaded btree_gist):
pramsey=# create table ttt as select * from counties;
SELECT
pramsey=# create index gid_bix on ttt using gist (gid);
CREATE INDEX
pramsey=# select count(*) from ttt;
count
-------
3141
(1 row)
pramsey=# cluster ttt using gid_bix;
CLUSTER
pramsey=# select count(*) from ttt;
count
-------
0
(1 row)
pramsey=# select version();
version
------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.3.5 on i386-apple-darwin9.5.0, compiled by GCC
i686-apple-darwin9-gcc-4.0.1 (GCC) 4.0.1 (Apple Inc. build 5465)
(1 row)
On Fri, Dec 5, 2008 at 6:05 AM, Gregory Stark <stark(at)enterprisedb(dot)com> wrote:
>
> Mark Cave-Ayland <mark(dot)cave-ayland(at)siriusit(dot)co(dot)uk> writes:
>
>> So in other words, the contents of the temporary table has just disappeared :(
>
> 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.
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
> Ask me about EnterpriseDB's Slony Replication support!
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2008-12-05 20:56:58 | Re: PLUGINS Functionlity in Win32 build scripts |
Previous Message | Nathan Boley | 2008-12-05 20:00:38 | Re: Simple postgresql.conf wizard |