Thread: file under data

file under data

From
"Leong, Fushan"
Date:
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?



Re: file under data

From
Stephan Szabo
Date:
On Tue, 30 Oct 2001, 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?

They're the databases and tables and such.  Deleting them would be bad.
If you want to see the number/name mappings check out contrib/oid2name



Re: file under data

From
David Stanaway
Date:
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


Re: file under data

From
"Leong, Fushan"
Date:
delete them is bad.. but you can not let them grow forever........

When and how to clean up these files?

thanks
Fushan

-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
Sent: Tuesday, October 30, 2001 4:56 PM
To: Leong, Fushan
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] file under data


On Tue, 30 Oct 2001, 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?

They're the databases and tables and such.  Deleting them would be bad.
If you want to see the number/name mappings check out contrib/oid2name


Re: file under data

From
Stephan Szabo
Date:
On Wed, 31 Oct 2001, Leong, Fushan wrote:

> delete them is bad.. but you can not let them grow forever........
>
> When and how to clean up these files?

You should VACUUM ANALYZE occasionally depending your rate of
updates and deletes on your tables.  I think you'll also need
to use REINDEX when you want to shrink the index space.  I
believe there's information about these commands in the
admin documentation.