From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | "Bossart, Nathan" <bossartn(at)amazon(dot)com> |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Bernd Helmle <mailings(at)oopsware(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: A few new options for CHECKPOINT |
Date: | 2020-12-04 21:46:34 |
Message-ID: | 20201204214634.GA13508@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On the UI of this patch, you're proposing to add the option FAST. I'm
not a fan of this option name and propose that (if we have it) we use
the name SPREAD instead (defaults to false).
Now we don't actually explain the term "spread" much in the documentation;
we just say "the writes are spread". But it seems more natural to build
on that adjective rather than "fast/slow".
I think starting a spread checkpoint has some usefulness, if your
checkpoint interval is very large but your completion target is not very
close to 1. In that case, you're expressing that you want a checkpoint
to start now and not impact production unduly, so that you know when it
finishes and therefore when is it a good time to start a backup. (You
will still have some WAL to replay, but it won't be as much as if you
just ignored checkpoint considerations completely.)
On the subject of measuring replay times for backups taking while
pgbench is pounding the database, I think a realistic test does *not*
have pgbench running at top speed; rather you have some non-maximal
"-R xyz" option. You would probably determine a value to use by running
without -R, observing what's a typical transaction rate, and using some
fraction (say, half) of that in the real run.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2020-12-04 22:00:48 | Re: POC: Better infrastructure for automated testing of concurrency issues |
Previous Message | Tom Lane | 2020-12-04 21:43:24 | Re: [PATCH] pg_dumpall options proposal/patch |