Author: Tom Sydney Kerckhove <syd@cs-syd.eu>
Committer: Tom Sydney Kerckhove <NorfairKing@users.noreply.github.com>
Stop waiting for a spread checkpoint when taking a base backup pg_basebackup waits for a checkpoint, and by default that checkpoint is spread over the checkpoint interval rather than taken at once. The wait is proportional to how busy the server is, and a server a standby is taken from is busy by definition: a suite is running against it. Asking for the checkpoint immediately is what --checkpoint=fast is for. This package's own suite goes from 78 seconds to a little over one, and starting a standby from about 13.5 seconds to about 0.17.
Total
1h20m20s
Created Started Finished
| Time to Start | Worker time | Duration | Time to finish | Idle | |
|---|---|---|---|---|---|
| Config | 1m01s | 1s | 1s | 1m02s | 1m01s |
| Eval | 1m23s | 12s | 12s | 1m36s | 20s |
| Build | 1m35s | 0s | 1h19m11s | 1h20m47s | 1h19m11s |
| Deploy | 1h20m58s | 23s | 23s | 1h21m22s | 11s |
| Suite | 1m01s | 37s | 1h20m20s | 1h21m22s | 1h20m44s |