| From: | David Stanaway <david(at)netventures(dot)com(dot)au> |
|---|---|
| To: | "Leong, Fushan" <fushan(dot)leong(at)SonoSite(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: file under data |
| Date: | 2001-10-31 01:04:03 |
| Message-ID: | 2D185862-CD9B-11D5-893D-0003930FDAB2@netventures.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)stanaway(dot)net
Work: david(at)netventures(dot)com(dot)au
| From | Date | Subject | |
|---|---|---|---|
| Next Message | leo | 2001-10-31 03:02:45 | How can I get the current connection number? |
| Previous Message | Stephan Szabo | 2001-10-31 00:56:21 | Re: file under data |