Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group