Re: 8.2 Autovacuum BUG ?

From: Pavan Teja <pavan(dot)postgresdba(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 8.2 Autovacuum BUG ?
Date: 2018-01-26 00:32:39
Message-ID: CACh9nsY=c=-Ne_NU-jrT+qAL9hRbUM3USOCr_nRiPskDeAYWkg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Jan 26, 2018 3:00 AM, "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Nandakumar M 2018-01-26 07:43:23 Re: Query is slow when run for first time; subsequent execution is fast
Previous Message Tomas Vondra 2018-01-25 21:36:00 Re: pg_xlog unbounded growth