What used so many spaces in PostgreSQL data folder?
What used so many spaces in PostgreSQL data folder?
От:
"cyz62578800" <cyz62578800@cmmail.com>
Дата:
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
Re: What used so many spaces in PostgreSQL data folder?
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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