Thread: file under data
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?
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
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
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
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.