condition). • Avoid improper response to shutdown signals in child processes just forked by system() (Nathan Bossart) This fix avoids a race condition in which a child process that has been forked off by system() connections” errors in pgbench on Windows (Noah Misch) • Fix vacuumdb's handling of multiple -N switches (Nathan Bossart, Kuwamura Masaki) Multiple -N switches should exclude tables in multiple schemas, but in (David Rowley) • Allow xid/subxid searches and ASCII string detection to use vector operations (Nathan Bossart, John Naylor) ASCII detection is particularly useful for COPY FROM. Vector operations are

condition). • Avoid improper response to shutdown signals in child processes just forked by system() (Nathan Bossart) This fix avoids a race condition in which a child process that has been forked off by system() connections” errors in pgbench on Windows (Noah Misch) • Fix vacuumdb's handling of multiple -N switches (Nathan Bossart, Kuwamura Masaki) Multiple -N switches should exclude tables in multiple schemas, but in (David Rowley) • Allow xid/subxid searches and ASCII string detection to use vector operations (Nathan Bossart, John Naylor) ASCII detection is particularly useful for COPY FROM. Vector operations are

condition). • Avoid improper response to shutdown signals in child processes just forked by system() (Nathan Bossart) This fix avoids a race condition in which a child process that has been forked off by system() creates a missing tablespace as an “in place” tablespace. • Fix permissions checks in CREATE INDEX (Nathan Bossart, Noah Misch) The fix for CVE-2022-1552 caused CREATE INDEX to apply the table owner's permissions these locks in the standard order. • Fix race condition between DROP TABLESPACE and checkpointing (Nathan Bossart) The checkpoint forced by DROP TABLESPACE could sometimes fail to remove all dead files

condition). • Avoid improper response to shutdown signals in child processes just forked by system() (Nathan Bossart) This fix avoids a race condition in which a child process that has been forked off by system() creates a missing tablespace as an “in place” tablespace. • Fix permissions checks in CREATE INDEX (Nathan Bossart, Noah Misch) The fix for CVE-2022-1552 caused CREATE INDEX to apply the table owner's permissions these locks in the standard order. • Fix race condition between DROP TABLESPACE and checkpointing (Nathan Bossart) The checkpoint forced by DROP TABLESPACE could sometimes fail to remove all dead files

Rename server variable session_auth_is_superuser to the more accurate current_role_is_superuser (Nathan Bossart) 1 https://www.postgresql.org/list/pgsql-committers/ 2 https://git.postgresql.org/gitweb/ their superuser status at connection time. • Remove feature which simulated per-database users (Nathan Bossart) The feature, db_user_namespace, was rarely used. • Remove wal_sync_method value fsync_writethrough vacuum_buffer_usage_limit to 2MB (Thomas Munro) • Improve performance when checking roles with many memberships (Nathan Bossart) • Improve performance of heavily-contended WAL writes (Bharath Rupireddy) 2682 Release

Rename server variable session_auth_is_superuser to the more accurate current_role_is_superuser (Nathan Bossart) • Change SET SESSION AUTHORIZATION handling of the initial session user's superuser status their superuser status at connection time. • Remove feature which simulated per-database users (Nathan Bossart) The feature, db_user_namespace, was rarely used. • Remove wal_sync_method value fsync_writethrough vacuum_buffer_usage_limit to 2MB (Thomas Munro) • Improve performance when checking roles with many memberships (Nathan Bossart) • Improve performance of heavily-contended WAL writes (Bharath Rupireddy) • Improve performance

condition). • Avoid improper response to shutdown signals in child processes just forked by system() (Nathan Bossart) This fix avoids a race condition in which a child process that has been forked off by system() creates a missing tablespace as an “in place” tablespace. • Fix permissions checks in CREATE INDEX (Nathan Bossart, Noah Misch) The fix for CVE-2022-1552 caused CREATE INDEX to apply the table owner's permissions standard order. 2692 Release Notes • Fix race condition between DROP TABLESPACE and checkpointing (Nathan Bossart) The checkpoint forced by DROP TABLESPACE could sometimes fail to remove all dead files

Notes • Avoid improper response to shutdown signals in child processes just forked by system() (Nathan Bossart) This fix avoids a race condition in which a child process that has been forked off by system() creates a missing tablespace as an “in place” tablespace. • Fix permissions checks in CREATE INDEX (Nathan Bossart, Noah Misch) The fix for CVE-2022-1552 caused CREATE INDEX to apply the table owner's permissions these locks in the standard order. • Fix race condition between DROP TABLESPACE and checkpointing (Nathan Bossart) The checkpoint forced by DROP TABLESPACE could sometimes fail to remove all dead files

condition). • Avoid improper response to shutdown signals in child processes just forked by system() (Nathan Bossart) This fix avoids a race condition in which a child process that has been forked off by system() creates a missing tablespace as an “in place” tablespace. • Fix permissions checks in CREATE INDEX (Nathan Bossart, Noah Misch) The fix for CVE-2022-1552 caused CREATE INDEX to apply the table owner's permissions these locks in the standard order. • Fix race condition between DROP TABLESPACE and checkpointing (Nathan Bossart) The checkpoint forced by DROP TABLESPACE could sometimes fail to remove all dead files

condition). • Avoid improper response to shutdown signals in child processes just forked by system() (Nathan Bossart) This fix avoids a race condition in which a child process that has been forked off by system() creates a missing tablespace as an “in place” tablespace. • Fix permissions checks in CREATE INDEX (Nathan Bossart, Noah Misch) The fix for CVE-2022-1552 caused CREATE INDEX to apply the table owner's permissions these locks in the standard order. • Fix race condition between DROP TABLESPACE and checkpointing (Nathan Bossart) The checkpoint forced by DROP TABLESPACE could sometimes fail to remove all dead files