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 DEE2132A1BA for ; Wed, 20 Oct 2004 01:50:26 +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 19094-05 for ; Wed, 20 Oct 2004 00:50:22 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 23A93329F30 for ; Wed, 20 Oct 2004 01:50:23 +0100 (BST) 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 i9K0oKJ7022942 for ; Wed, 20 Oct 2004 00:50:20 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i9K0o22r022881 for pgsql-admin@postgresql.org; Wed, 20 Oct 2004 00:50:02 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: pgsql database .1 .2 .3 file names Date: Tue, 19 Oct 2004 20:29:01 -0400 Organization: cbbrowne Computing Inc Lines: 27 Message-ID: References: <41753D3F.1020204@tds.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:y9hvxjMBZyoG7EMtqYFA3hMa0jc= To: pgsql-admin@postgresql.org 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/253 X-Sequence-Number: 15246 The world rejoiced as bbiggers@tds.net (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 You might just want to keep those files. They're the data for some table that evidently occupies about 6.5GB of space. It's _possible_ that the table needs vacuuming, in which case some of that space might be reclaimed. But you'd best do that using VACUUM. Deleting files would be expected to amount to destroying about a GB apiece of the data in the table... -- let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];; http://www.ntlug.org/~cbbrowne/internet.html As of next Monday, TRIX will be flushed in favor of VISI-CALC. Please update your programs.