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

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: High CPU load on Postgres Server during Peak times!!!!
Дата
Msg-id 2f4958ff0909250116p51900f60yf845cc4ad052eaad@mail.gmail.com
обсуждение исходный текст
Ответ на Re: High CPU load on Postgres Server during Peak times!!!!  (Shiva Raman <raman.shivag@gmail.com>)
Ответы Re: High CPU load on Postgres Server during Peak times!!!!  (Shiva Raman <raman.shivag@gmail.com>)
Список pgsql-performance
Дерево обсуждения


On Fri, Sep 25, 2009 at 9:06 AM, Shiva Raman <raman.shivag@gmail.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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Shiva Raman
Дата:
Сообщение: Re: High CPU load on Postgres Server during Peak times!!!!
Следующее
От: Shiva Raman
Дата:
Сообщение: Re: High CPU load on Postgres Server during Peak times!!!!