X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BD091D1E106 for ; Thu, 26 Feb 2004 20:49:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 88095-09 for ; Thu, 26 Feb 2004 16:49:33 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id BEA3AD1BA21 for ; Thu, 26 Feb 2004 16:49:31 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i1QKnV1Y098204 for ; Thu, 26 Feb 2004 20:49:31 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i1QKM7oE093124 for pgsql-admin@postgresql.org; Thu, 26 Feb 2004 20:22:07 GMT X-Abuse-Report: abuse@teranews.com Message-ID: <553ba30262d1440fc971876f7cdcd11a@news.teranews.com> Date: Thu, 26 Feb 2004 20:10:15 GMT Lines: 13 From: Jeff Boes Organization: Nexcerpt, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 X-Newsgroups: comp.databases.postgresql.admin Subject: un-CLUSTER? Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/362 X-Sequence-Number: 12536 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