Re: 8.2 Autovacuum BUG ?

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: 8.2 Autovacuum BUG ?
Дата
Msg-id CAGTBQpYhg_Ow3SBmUd4=ycepDp5eJin-ou1kBAasQ5EyuE-n+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 8.2 Autovacuum BUG ?  (Pavan Teja <pavan.postgresdba@gmail.com>)
Ответы Re: 8.2 Autovacuum BUG ?
Список pgsql-performance


On Tue, Jan 23, 2018 at 11:39 AM, Pavan Teja <pavan.postgresdba@gmail.com> wrote:
Yes so many wals are continuing to be produced.

Deleting the wals after a backup of the database.

Yes archiving mode is on. And the warning message in log file is 

" checkpoints are frequently occurring (1second apart). Consider increasing checkpoint_segements parameter".

My doubt is previously the same are the parameters which are reflected as of now. Then what is the point in considering altering those values. Correct me if I am wrong.

You can use pg_xlogdump to inspect those logs and see which relations/transactions are generating so much WAL.

Then you can hunt within your apps which code is responsible for that traffic, or whether it in fact is autovacuum.
 

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

Предыдущее
От: Laurent Martelli
Дата:
Сообщение: Re: Bad plan
Следующее
От: Pavan Teja
Дата:
Сообщение: Re: 8.2 Autovacuum BUG ?