Tuning with wait events for RDS for PostgreSQL (original) (raw)

DocumentationAmazon RDSUser Guide

Wait events are an important tuning tool for RDS for PostgreSQL. When you can find out why sessions are waiting for resources and what they are doing, you're better able to reduce bottlenecks. You can use the information in this section to find possible causes and corrective actions. This section also discusses basic PostgreSQL tuning concepts.

The wait events in this section are specific to RDS for PostgreSQL.

Topics

• Essential concepts for RDS for PostgreSQL tuning
• RDS for PostgreSQL wait events
• Client:ClientRead
• Client:ClientWrite
• CPU
• IO:BufFileRead and IO:BufFileWrite
• IO:DataFileRead
• IO:WALWrite
• Lock:advisory
• Lock:extend
• Lock:Relation
• Lock:transactionid
• Lock:tuple
• LWLock:BufferMapping (LWLock:buffer_mapping)
• LWLock:BufferIO (IPC:BufferIO)
• LWLock:buffer_content (BufferContent)
• LWLock:lock_manager (LWLock:lockmanager)
• Timeout:PgSleep
• Timeout:VacuumDelay

Document Conventions

Working with parameters

Essential concepts for RDS for PostgreSQL tuning

Did this page help you? - Yes

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Did this page help you? - No

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.