Skip site navigation (1) Skip section navigation (2)

un-CLUSTER?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: un-CLUSTER?
Date: 2004-02-26 20:10:15
Message-ID: 553ba30262d1440fc971876f7cdcd11a@news.teranews.com (view raw or flat)
Thread:
Lists: pgsql-admin
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).

-- 
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
            ...Nexcerpt... Extend your Expertise

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2004-02-26 22:34:09
Subject: Re: un-CLUSTER?
Previous:From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]Date: 2004-02-26 18:11:38
Subject: Re: pg_restore data block error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group