From: | Tiemen Ruiten <t(dot)ruiten(at)tech-lab(dot)io> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: checkpoints taking much longer than expected |
Date: | 2019-06-15 08:49:38 |
Message-ID: | CAEkBuzdUpqh5fMDGRC661ffWukFNUESxXs8ByrVrj6O9kDCs3g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jun 14, 2019 at 5:43 PM Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> Greetings,
>
> * Tiemen Ruiten (t(dot)ruiten(at)tech-lab(dot)io) wrote:
> > checkpoint_timeout = 60min
>
> That seems like a pretty long timeout.
>
My reasoning was that a longer recovery time to avoid writes would be
acceptable because there are two more nodes in the cluster to fall back on
in case of emergency.
>
> > My problem is that checkpoints are taking a long time. Even when I run a
> > few manual checkpoints one after the other, they keep taking very long,
> up
> > to 10 minutes:
>
> You haven't said *why* this is an issue... Why are you concerned with
> how long it takes to do a checkpoint?
>
During normal operation I don't mind that it takes a long time, but when
performing maintenance I want to be able to gracefully bring down the
master without long delays to promote one of the standby's.
>
> The time information is all there and it tells you what it's doing and
> how much had to be done... If you're unhappy with how long it takes to
> write out gigabytes of data and fsync hundreds of files, talk to your
> storage people...
>
I am the storage people too :)
>
> Thanks,
>
> Stephen
>
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2019-06-15 09:36:21 | Re: how to concat/concat_ws all fields without braces |
Previous Message | Rob Nikander | 2019-06-15 06:32:51 | arrays of composite types, and client drivers like JDBC |