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

From: Shiva Raman <raman(dot)shivag(at)gmail(dot)com>
To: Gerhard Wiesinger <gerhard(at)wiesinger(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: High CPU load on Postgres Server during Peak times!!!!
Date: 2009-09-25 08:06:46
Message-ID: 25bf489c0909250106n2b2f4222p123f9579d9b66abf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-09-25 08:16:25 Re: High CPU load on Postgres Server during Peak times!!!!
Previous Message Shiva Raman 2009-09-25 07:17:43 Re: High CPU load on Postgres Server during Peak times!!!!