Re: What  used  so  many  spaces  in  PostgreSQL  data  folder?

I wrote a manual page section on this for 7.3:

http://developer.postgresql.org/docs/postgres/diskusage.html

The short answer is that we changed to numeric file names in 7.1.

---------------------------------------------------------------------------

cyz62578800 wrote:
> Hello,
>
> i installed Psql-7.1.3 on my RedHat6.2 server in /usr/loc
> al/pgsql,after i create a database,there would be a subfolde
> r created in /usr/local/pgsql/data/base,where stored data of
> this database.
> today,i found that the usage of space increased more 200
> MB,it caused by some big files about 200 or 300 MB created,
> for examples,the database folder named "6302683", part of all files,including some big files are listed below:
>
> -rw------- 1 postgres postgres 16384 Jul 31 10:38 6302776
> -rw------- 1 postgres postgres 8192 Jul 31 10:38 6302779
> -rw------- 1 postgres postgres 34996224 Aug 1 10:01 6302790
> -rw------- 1 postgres postgres 243318784 Aug 1 09:59 6302824
> -rw------- 1 postgres postgres 4104192 Aug 1 09:59 6302836
> -rw------- 1 postgres postgres 950272 Aug 1 10:01 6302839
> -rw------- 1 postgres postgres 8192 Jul 31 13:29 6302842
> -rw------- 1 postgres postgres 1245184 Jul 31 13:31 6302853
>
>
> i don't kown why this happened.i am sure that this is not
> caused by adding normal data into my database by clients.
> What's the problem & How to solve it ??
> (BTW,i remembered that when i read docs of PostgreSQL Admin
> or User Guide,one line suggested that i should create sth in
> Crond daemon to "clean" sth EVERYDAY or EVERY HOUR,by i could not find it exactly,maybe related with my question...)
>
>
> Peter
>
>
>
>
>
>
>
>
>
> ---------------------------------------------
> http://www.cmmail.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026