| From: | Shiva Raman <raman(dot)shivag(at)gmail(dot)com> |
|---|---|
| To: | Grzegorz Jaśkiewicz <gryzman(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:55:23 |
| Message-ID: | 25bf489c0909250155h6b26bddeo91e595e1b3cdef1a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)gmail(dot)com>
>
> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaśkiewicz | 2009-09-25 09:03:05 | Re: High CPU load on Postgres Server during Peak times!!!! |
| Previous Message | Grzegorz Jaśkiewicz | 2009-09-25 08:16:25 | Re: High CPU load on Postgres Server during Peak times!!!! |