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

Поиск
Список
Период
Сортировка
От Rosser Schwarz
Тема Re: pgsql database .1 .2 .3 file names
Дата
Msg-id 37d451f704101912575338e3ea@mail.gmail.com
обсуждение исходный текст
Ответ на pgsql database .1 .2 .3 file names  (Bryan Biggers <bbiggers@tds.net>)
Список 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 по дате отправления:

Предыдущее
От: Bryan Biggers
Дата:
Сообщение: pgsql database .1 .2 .3 file names
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql database .1 .2 .3 file names