X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D5A32528C6 for ; Mon, 13 Jun 2005 13:44:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66821-07 for ; Mon, 13 Jun 2005 16:44:32 +0000 (GMT) Received: from web51406.mail.yahoo.com (web51406.mail.yahoo.com [206.190.38.185]) by svr1.postgresql.org (Postfix) with SMTP id 84C2E528B2 for ; Mon, 13 Jun 2005 13:44:30 -0300 (ADT) Received: (qmail 12979 invoked by uid 60001); 13 Jun 2005 16:44:30 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=frNUeTOjBxZzpdy7nY8livWofq8M4wLux9fOXCqkabx13OgJPpuww7NOgbCTB/4VTIQbAviYX8pRYy3GJ2yOplFbkOIgdJf19NlNGN525jgsnj5rEJMQeIqol2BfbKM4Rm8liphH0oYU205Blg3fXfmUDd5YqmBTOvlVldLd5xM= ; Message-ID: <20050613164430.12977.qmail@web51406.mail.yahoo.com> Received: from [160.79.92.198] by web51406.mail.yahoo.com via HTTP; Mon, 13 Jun 2005 09:44:30 PDT Date: Mon, 13 Jun 2005 09:44:30 -0700 (PDT) From: Amir Becher Subject: Error Using CLUSTER To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.75 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200506/87 X-Sequence-Number: 17842 I started using CLUSTER a few weeks ago and it worked (no errors) and the performance of the database improved. However, When I ran CLUSTER again, I got the following error: ERROR: cannot create pg_temp_2558977013: File exists Here is more information that may or may not be relevant: 1. I am running PostgreSQL 7.3.1. 2. The table has a little more than 16 million records 3. I am pretty sure I am not running out of disk space: The size of the partition is 126 gigabytes and only 28 gigabytes are used. 4. The table has 5 columns: (int, date, date, float date) 5. There is one index on the table: (int, date, date). Is my database corrupt? Will CLUSTER corrupt my tables if it doesn't finish successfully? Thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com