Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding CLUSTERING removed my indexes - Mailing list pgsql-novice

From Tom Lane
Subject Re: Adding CLUSTERING removed my indexes
Date
Msg-id 12431.1014339891@sss.pgh.pa.us
Whole thread Raw
In response to Adding CLUSTERING removed my indexes  (Jon Hassen <jhassen@azstarnet.com>)
Responses Re: Adding CLUSTERING removed my indexes  (Jason Earl <jason.earl@simplot.com>)
List pgsql-novice
Tree view 
Jon Hassen <jhassen@azstarnet.com> writes:
> All of my indexes disappeared, and the permissions changed on my tables
> after I ran the CLUSTER command on one of the indexes.

> Is this normal?

The present implementation of the CLUSTER command pretty much sucks (see
the Notes on its reference page).  Sooner or later someone will rewrite
it ...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Keller, Sid"
Date:
Subject: Logging Apache web server log information to Postgresql
Next
From: Singer Wang
Date:
Subject: Re: Logging Apache web server log information to Postgresql