Re: 8.2 Autovacuum BUG ?

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: Pavan Teja <pavan(dot)postgresdba(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: 8.2 Autovacuum BUG ?
Date: 2018-01-23 14:57:40
Message-ID: 7a940ec2-6ac1-c8fc-6a99-74c1e8536a42@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Please don't top-posting

Am 23.01.2018 um 15:39 schrieb Pavan Teja:
> Yes so many wals are continuing to be produced.

you have to identify why. Please check pg_stat_activity for
* autovacuum
* large inserts
* large updates
* large deletes

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2018-01-23 15:18:48 Re: Bad plan
Previous Message David G. Johnston 2018-01-23 14:45:14 Re: 8.2 Autovacuum BUG ?