Re: file under data

Поиск
Список
Период
Сортировка
От David Stanaway
Тема Re: file under data
Дата
Msg-id 2D185862-CD9B-11D5-893D-0003930FDAB2@netventures.com.au
обсуждение исходный текст
Ответ на file under data  ("Leong, Fushan" <fushan.leong@SonoSite.com>)
Список pgsql-admin
On Wednesday, October 31, 2001, at 11:26  AM, Leong, Fushan wrote:

> Hi :
>
>    Very new in postgres.  I created a database and did some
> transactions.  I
> found three subdirectories are created under $HOME/data/base.  They
> are  1,
> 18719, 18720.  Under these "funny" name directory, there are a lot of
> files
> with number as their filename.
>
> What are they?  Can I delete them when my disk space is very tide?


The directories under /date/base  are databases.  The number coresponds
to their oid
the files in those directories are tables and indexes etc..

You may want to look into the vacuumdb command


==============================
David Stanaway
Personal: david@stanaway.net
Work: david@netventures.com.au


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Leong, Fushan"
Дата:
Сообщение: file under data
Следующее
От: "Wiecha, Martin"
Дата:
Сообщение: performnce problem