| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-26 22:34:09 | Re: un-CLUSTER? |
| Previous Message | V i s h a l Kashyap @ [Sai Hertz And Control Systems] | 2004-02-26 18:11:38 | Re: pg_restore data block error |