Re: pgsql database .1 .2 .3 file names

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Bryan Biggers <bbiggers(at)tds(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgsql database .1 .2 .3 file names
Date: 2004-10-19 19:57:33
Message-ID: 37d451f704101912575338e3ea@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

while you weren't looking, 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.

Delete them at your peril.

Really quickly, what does 1073741824 / 1024 / 1024 / 1024 equal?

Data files are partitioned at 1GiB boundaries; deleting one of those
files would blow away roughly 1/7 of whichever table has an OID of
19523580.

/rls

--
:wq

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-10-19 20:05:11 Re: pgsql database .1 .2 .3 file names
Previous Message Richard_D_Levine 2004-10-19 18:51:58 Re: NIC to NIC connection