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

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

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Shiva Raman <raman(dot)shivag(at)gmail(dot)com>
Cc: 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:16:25
Message-ID: 2f4958ff0909250116p51900f60yf845cc4ad052eaad@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Sep 25, 2009 at 9:06 AM, Shiva Raman <raman(dot)shivag(at)gmail(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Shiva RamanDate: 2009-09-25 08:55:23
Subject: Re: High CPU load on Postgres Server during Peak times!!!!
Previous:From: Shiva RamanDate: 2009-09-25 08:06:46
Subject: Re: High CPU load on Postgres Server during Peak times!!!!

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