Database Reference
In-Depth Information
The WAL receiver process will wake up every 100ms to check if new replication data has arrived.
If no new data has arrived, it will sleep again. That time cannot be changed by a parameter.
Autovacuum will wake up every 60s by default. This can be changed by altering the
setting of
autovacuum_naptime
. Autovacuum can be disabled completely by setting
autovacuum
=
off
.
So, if you are using Streaming Replication, then the server will wake up every 100ms. If not,
then you can reduce the wakeup time to every 10s rather than every 200ms, which is the
default setting.
