[Postgres] Monitor wait event
\t
select wait_event_type, wait_event from pg_stat_activity where pid !=pg_backend_pid();
\watch 0.5
En poursuivant votre navigation sur ce site, vous acceptez l'utilisation de cookies. Ces derniers assurent le bon fonctionnement de nos services. En savoir plus.
\t
select wait_event_type, wait_event from pg_stat_activity where pid !=pg_backend_pid();
\watch 0.5
Click her to see the next.
This site helped to resolve IPC wait event : Postgres checkpoint tuning | Tembo Docs
You have to adapt the checkpoint_timeout within the max_wal_size.
If the max_wal_size is 8Go then you can increase the default value of checkpoint_timeout (which is 5 min).
For big database with big wal size, you need to increase the checkpoint_timeout to avoid IPC wait event on the Buffers.