Re: 8.2 Autovacuum BUG ? - Mailing list pgsql-performance

From Claudio Freire
Subject Re: 8.2 Autovacuum BUG ?
Date
Msg-id CAGTBQpYhg_Ow3SBmUd4=ycepDp5eJin-ou1kBAasQ5EyuE-n+A@mail.gmail.com
Whole thread Raw
In response to Re: 8.2 Autovacuum BUG ?  (Pavan Teja <pavan.postgresdba@gmail.com>)
Responses Re: 8.2 Autovacuum BUG ?  (Pavan Teja <pavan.postgresdba@gmail.com>)
List 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 by date:

Previous
From: Laurent Martelli
Date:
Subject: Re: Bad plan
Next
From: Pavan Teja
Date:
Subject: Re: 8.2 Autovacuum BUG ?