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 по дате отправления: