I/O error being reported. It is not necessary to use the sync mount option. The behavior of the async option is sufficient, since PostgreSQL issues fsync calls at appropriate times to flush the write for specific columns using ALTER TABLE SET STATISTICS. enable_async_append (boolean) Enables or disables the query planner's use of async-aware append plan types. The default is on. enable_bitmapscan Repl. Write- Ahead Log Shipping Logical Repl. Trigger- Based Repl. SQL Re- pl. Mid- dle-ware Async. MM Re- pl. Sync. MM Re- pl. Popular examples NAS DRBD built-in stream- ing repl. built-in logical

I/O error being reported. It is not necessary to use the sync mount option. The behavior of the async option is sufficient, since PostgreSQL issues fsync calls at appropriate times to flush the write Repl. Write- Ahead Log Shipping Logical Repl. Trigger- Based Repl. SQL Re- pl. Mid- dle-ware Async. MM Re- pl. Sync. MM Re- pl. Popular examples NAS DRBD built-in stream- ing repl. built-in logical Repl. Write- Ahead Log Shipping Logical Repl. Trigger- Based Repl. SQL Re- pl. Mid- dle-ware Async. MM Re- pl. Sync. MM Re- pl. never lose data Replicas accept read-only queries with hot standby

off- set buffer. multixact_member Waiting for I/O on a multixac- t_member buffer. async Waiting for I/O on an async (noti- fy) buffer. oldserxid Waiting to I/O on an oldserxid buffer. wal_insert Waiting nous replication. sync_state text Synchronous state of this standby server. Possible values are: • async: This standby server is asynchronous. • potential: This standby server is now asynchronous, but can COPY_OUT state. int PQgetCopyData(PGconn *conn, char **buffer, int async); Attempts to obtain another row of data from the server during a COPY. Data is always returned one

certain inter- nal operations such as relation extension. wait_event will identify the type of lock await- ed. • BufferPin: The server process is waiting to access to a data buffer during a period when multixact offset buffer. multixact_member Waiting for I/O on a multixac- t_member buffer. async Waiting for I/O on an async (no- tify) buffer. oldserxid Waiting to I/O on an oldserxid buffer. 679 Monitoring replication. sync_state text Synchronous state of this stand- by server. Possible values are: • async: This standby server is asynchronous. • potential: This standby server is now asynchronous, but can

I/O error being reported. It is not necessary to use the sync mount option. The behavior of the async option is sufficient, since PostgreSQL issues fsync calls at appropriate times to flush the write for specific columns using ALTER TABLE SET STATISTICS. enable_async_append (boolean) Enables or disables the query planner's use of async-aware append plan types. The default is on. enable_bitmapscan Repl. Write- Ahead Log Shipping Logical Repl. Trigger- Based Repl. SQL Re- pl. Mid- dle-ware Async. MM Re- pl. Sync. MM Re- pl. Popular examples NAS DRBD built-in stream- ing repl. built-in logical

I/O error being reported. It is not necessary to use the sync mount option. The behavior of the async option is sufficient, since PostgreSQL issues fsync calls at appropriate times to flush the write for specific columns using ALTER TABLE SET STATISTICS. enable_async_append (boolean) Enables or disables the query planner's use of async-aware append plan types. The default is on. enable_bitmapscan Repl. Write- Ahead Log Shipping Logical Repl. Trigger- Based Repl. SQL Re- pl. Mid- dle-ware Async. MM Re- pl. Sync. MM Re- pl. Popular examples NAS DRBD built-in stream- ing repl. built-in logical

I/O error being reported. It is not necessary to use the sync mount option. The behavior of the async option is sufficient, since PostgreSQL issues fsync calls at appropriate times to flush the write for specific columns using ALTER TABLE SET STATISTICS. enable_async_append (boolean) Enables or disables the query planner's use of async-aware append plan types. The default is on. enable_bitmapscan Repl. Write- Ahead Log Shipping Logical Repl. Trigger- Based Repl. SQL Re- pl. Mid- dle-ware Async. MM Re- pl. Sync. MM Re- pl. Popular examples NAS DRBD built-in stream- ing repl. built-in logical

I/O error being reported. It is not necessary to use the sync mount option. The behavior of the async option is sufficient, since PostgreSQL issues fsync calls at appropriate times to flush the write certain inter- nal operations such as relation extension. wait_event will identify the type of lock await- ed. • BufferPin: The server process is waiting to access to a data buffer during a period when multixact offset buffer. multixact_member Waiting for I/O on a multixac- t_member buffer. async Waiting for I/O on an async (no- tify) buffer. oldserxid Waiting for I/O on an oldserxid buffer. wal_insert Waiting

I/O error being reported. It is not necessary to use the sync mount option. The behavior of the async option is sufficient, since PostgreSQL issues fsync calls at appropriate times to flush the write off- set buffer. multixact_member Waiting for I/O on a multixac- t_member buffer. async Waiting for I/O on an async (noti- fy) buffer. oldserxid Waiting for I/O on an oldserxid buffer. wal_insert Waiting nous replication. sync_state text Synchronous state of this standby server. Possible values are: • async: This standby server is asynchronous. • potential: This standby server is now asynchronous, but can

certain inter- nal operations such as relation extension. wait_event will identify the type of lock await- ed. • BufferPin: The server process is waiting to access to a data buffer during a period when buffer. 717 Monitoring Database Activity Wait Event Type Wait Event Name Description async Waiting for I/O on an async (no- tify) buffer. oldserxid Waiting for I/O on an oldserxid buffer. wal_insert Waiting stand- by server. Possible values are: 727 Monitoring Database Activity Column Type Description • async: This standby server is asynchronous. • potential: This standby server is now asynchronous, but can