Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group