Re: [ADMIN] Help on maintaining pgsql/data folder size

2005-03-07 Thread Pradeepkumar, Pyatalo (IE10)
Hi Tom, > pg_xlog shouldn't grow unreasonably big unless you've somehow turned off checkpointing. pg_clog shouldn't grow unreasonably big unless you've neglected > appropriate vacuuming procedures (see the manual). So I think this is mostly pilot error. After going through the manual, I chang

Re: [ADMIN] Help on maintaining pgsql/data folder size

2005-03-07 Thread KÖPFERL Robert
ubject: [ADMIN] Help on maintaining pgsql/data folder size Hi all, I am using PostgreSQL 7.4.3. The problem I am facing is that the size of pgsql/data folder keeps increasing and at a point the it takes up all the disk space and it freezes the system. The pg_xlog and the pg_clog folde

Re: [ADMIN] Help on maintaining pgsql/data folder size

2005-03-07 Thread Tom Lane
"Pradeepkumar, Pyatalo (IE10)" <[EMAIL PROTECTED]> writes: > I am using PostgreSQL 7.4.3. The problem I am facing is that the size of > pgsql/data folder keeps increasing and at a point the it takes up all the > disk space and it freezes the system. The pg_xlog and the pg_clog folders > are taking

[ADMIN] Help on maintaining pgsql/data folder size

2005-03-06 Thread Pradeepkumar, Pyatalo (IE10)
Title: Help on maintaining pgsql/data folder size Hi all, I am using PostgreSQL 7.4.3. The problem I am facing is that the size of pgsql/data folder keeps increasing and at a point the it takes up all the disk space and it freezes the system. The pg_xlog and the pg_clog folders are taking u