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@postgresql.org
>

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