un-CLUSTER?

[Jeff Boes]

Is there a way to turn off the CLUSTER setting for a table?

I did a "CLUSTER index ON table" for a number of tables. Now I want to
do a raw CLUSTER command across the whole database, but I'd really like
to turn off the CLUSTER setting for one of the tables (because it takes
too long). I don't see anything that will allow me to do that (other
than dropping and recreating the table).

[Tom Lane]

Post by Jeff Boes
Is there a way to turn off the CLUSTER setting for a table?

I think you'd just have to reach in and turn off the indisclustered
(sp?) flag in the appropriate row of pg_index.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Bruce Momjian]

Post by Tom Lane

Post by Jeff Boes
Is there a way to turn off the CLUSTER setting for a table?

I think you'd just have to reach in and turn off the indisclustered
(sp?) flag in the appropriate row of pg_index.

Added to TODO:

Add way to remove cluster specification on a table
--
Bruce Momjian | http://candle.pha.pa.us
***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org