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