Re: 8.2 Autovacuum BUG ?

[Pavan Teja <pavan.postgresdba@xxxxxxxxx>]

On Jan 26, 2018 3:00 AM, "Alvaro Herrera" <alvherre@xxxxxxxxxxxxxx> wrote:

pavan95 wrote:
> Hi Álvaro Herrera,
>
> Please find the corresponding output:

OK, these settings look pretty normal, so they don't explain your
problem.

What is checkpoint_segments set to?  And checkpoint_timeout?

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

    Hi,

      checkpoint_segments are set to '3' &

      checkpoint_timeout was set to '5                min'.

     Regards,

     Pavan.