From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: pgsql database .1 .2 .3 file names
Date: Tue, 19 Oct 2004 20:29:01 -0400
Message-ID: <m3u0sqb5bm.fsf@knuth.knuth.cbbrowne.com> (raw)
References: <41753D3F.1020204@tds.net>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: pgsql database .1 .2 .3 file names
In-Reply-To: <m3u0sqb5bm.fsf@knuth.knuth.cbbrowne.com>
References: <41753D3F.1020204@tds.net> <m3u0sqb5bm.fsf@knuth.knuth.cbbrowne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox