Re: pgsql database .1 .2 .3 file names - Mailing list pgsql-admin

From Rosser Schwarz
Subject Re: pgsql database .1 .2 .3 file names
Date
Msg-id 37d451f704101912575338e3ea@mail.gmail.com
Whole thread Raw
In response to pgsql database .1 .2 .3 file names  (Bryan Biggers <bbiggers@tds.net>)
List 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

pgsql-admin by date:

Previous
From: Bryan Biggers
Date:
Subject: pgsql database .1 .2 .3 file names
Next
From: Tom Lane
Date:
Subject: Re: pgsql database .1 .2 .3 file names