Postgres Pro
Downloads
Home   >   mailing lists

Re: High CPU load on Postgres Server during Peak times!!!! - Mailing list pgsql-performance

From Shiva Raman
Subject Re: High CPU load on Postgres Server during Peak times!!!!
Date
Msg-id 25bf489c0909250106n2b2f4222p123f9579d9b66abf@mail.gmail.com
Whole thread Raw
In response to Re: High CPU load on Postgres Server during Peak times!!!!  (Shiva Raman <raman.shivag@gmail.com>)
Responses Re: High CPU load on Postgres Server during Peak times!!!!  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-performance
Tree view
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 .
 pg_xlog and pg_clog has nearly less than 25 Mb of data only.


Regds

Shiva Raman



pgsql-performance by date:

Previous
From: Shiva Raman
Date:
Subject: Re: High CPU load on Postgres Server during Peak times!!!!
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: High CPU load on Postgres Server during Peak times!!!!