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 F35EC329E61 for ; Tue, 19 Oct 2004 21:10:06 +0100 (BST) 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 28728-10 for ; Tue, 19 Oct 2004 20:09:55 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 30CA8329E25 for ; Tue, 19 Oct 2004 21:09:56 +0100 (BST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 7CF76353E4; Tue, 19 Oct 2004 13:09:55 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 7B7FF3504A; Tue, 19 Oct 2004 13:09:55 -0700 (PDT) Date: Tue, 19 Oct 2004 13:09:55 -0700 (PDT) From: Stephan Szabo To: Bryan Biggers Cc: pgsql-admin@postgresql.org Subject: Re: pgsql database .1 .2 .3 file names In-Reply-To: <41753D3F.1020204@tds.net> Message-ID: <20041019130704.W67565@megazone.bigpanda.com> References: <41753D3F.1020204@tds.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/248 X-Sequence-Number: 15241 On Tue, 19 Oct 2004, Bryan Biggers wrote: > Can anyone tell me what the data file names with the .1 .2 .3 etc. > extensions are? Are these undo versions of my tables or something? I > need to recover some disk space and I'm wondering if I need them. Here > is an example... > -rw------- 1 postgres postgres 1073741824 Oct 18 20:01 19523580 > -rw------- 1 postgres postgres 1073741824 Sep 6 20:11 19523580.1 > -rw------- 1 postgres postgres 1073741824 Sep 6 20:11 19523580.2 > -rw------- 1 postgres postgres 1073741824 Sep 6 20:11 19523580.3 > -rw------- 1 postgres postgres 1073741824 Sep 6 20:11 19523580.4 > -rw------- 1 postgres postgres 1073741824 Oct 6 20:19 19523580.5 > -rw------- 1 postgres postgres 629948416 Oct 19 12:33 19523580.6 Those are further extents of the table after 1G. The table gets broken to try to prevent running into any issues with >=2G files.