pgsql: Remove pg_authid's TOAST table.

2024-09-21 Thread Nathan Bossart
Remove pg_authid's TOAST table. pg_authid's only varlena column is rolpassword, which unfortunately cannot be de-TOASTed during authentication because we haven't selected a database yet and cannot read pg_class. By removing pg_authid's TOAST table, attempts to set password hashes that require out

pgsql: Increase the number of fast-path lock slots

2024-09-21 Thread Tomas Vondra
Increase the number of fast-path lock slots Replace the fixed-size array of fast-path locks with arrays, sized on startup based on max_locks_per_transaction. This allows using fast-path locking for workloads that need more locks. The fast-path locking introduced in 9.2 allowed each backend to acq

pgsql: Refactor handling of nbtree array redundancies.

2024-09-21 Thread Peter Geoghegan
Refactor handling of nbtree array redundancies. Teach _bt_preprocess_array_keys to eliminate redundant array equality scan keys directly, rather than just marking them as redundant. Its _bt_preprocess_keys caller is no longer required to ignore input scan keys that were marked redundant in this w