PostgreSQL 性能优化: 等待事件
等待事件
等待事件是 PostgreSQL 的重要优化工具。当您能查明会话为什么在等待资源以及会话在做什么时，您就能更好地减少瓶颈。您可以使用本节中的信息来查找可能的原因和纠正措施。
目录
- 等待事件概述
- BufferPin
- Client - ClientRead
- Client - ClientWrite
- CPU
- Extension
- IO - BufFileRead
- IO - BufFileWrite
- IO - ControlFileWriteUpdate
- IO - DataFileImmediateSync
- IO - DataFileRead
- IO - DSMFillZeroWrite
- IO - WALSync
- IO - WALWrite
- IPC - ExecuteGather
- IPC - ParallelBitmapScan
- IPC - ParallelCreateIndexScan
- IPC - ParallelFinish
- Lock - advisory
- Lock - extend
- Lock - relation
- Lock - transactionid
- Lock - tuple
- LWLock - buffer_content
- LWLock - buffer_io
- LWLock - buffer_mapping
- LWLock - lock_manager
- LWLock - WALWriteLock
- Timeout - PgSleep