Re: High CPU load on Postgres Server during Peak times!!!!

As suggested, i had changed the log_statement='ddl' and now it is logging only
the ddl statements . thanks for the tip.
 Can i delete the old log files in pg_log after backing up as zip archive ? is it neccesary to keep those log files ?

Regards

Shiva Raman

2009/9/25 Grzegorz Jaśkiewicz <gryzman@gmail.com>

On Fri, Sep 25, 2009 at 9:06 AM, Shiva Raman <raman.shivag@gmail.com> wrote:

Hi Gerhard
 I also found the pg_log has 73 G of data .

clusternode2:/var/lib/pgsql/data # du -sh pg_log/
73G     pg_log/

Is it necessary to keep this Log files? Can i backup the logs and delete it from the original directory ? Is this logs files necessary in case any data recovery to be done ?
I am database dumps every day .

you're probably logging too much. Change level of logging (log_statement to ddl for instance), and do 'pg_ctl reload'

--
GJ