Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavan Teja
Subject Re: 8.2 Autovacuum BUG ?
Date
Msg-id CACh9nsY=c=-Ne_NU-jrT+qAL9hRbUM3USOCr_nRiPskDeAYWkg@mail.gmail.com
Whole thread Raw
In response to Re: 8.2 Autovacuum BUG ?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: 8.2 Autovacuum BUG ?
List pgsql-performance
Tree view


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

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: pg_xlog unbounded growth
Next
From: Nandakumar M
Date:
Subject: Re: Query is slow when run for first time; subsequent execution is fast