pgsql: docs: Clarify that signal functions have no feedback.

2020-11-18 Thread Heikki Linnakangas
docs: Clarify that signal functions have no feedback. Bug #16652 complains that pg_reload_conf() returned true, even though the configuration file contained errors. That's the way pg_reload_conf() works, by design, but the documentation wasn't very clear on it. Clarify that a 'true' return value o

pgsql: Skip allocating hash table in EXPLAIN-only mode.

2020-11-18 Thread Heikki Linnakangas
Skip allocating hash table in EXPLAIN-only mode. Author: Alexey Bashtanov Discussion: https://www.postgresql.org/message-id/36823f65-050d-ae24-aa4d-a37726998240%40imap.cc Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/2cccb627f10d5dd4c21806fa251e4fb61eadd28c Modi

pgsql: Relax lock level for setting PGPROC->statusFlags

2020-11-18 Thread Alvaro Herrera
Relax lock level for setting PGPROC->statusFlags We don't actually need a lock to set PGPROC->statusFlags itself; what we do need is a shared lock on either XidGenLock or ProcArrayLock in order to ensure MyProc->pgxactoff keeps still while we modify the mirror array in ProcGlobal->statusFlags. So

pgsql: Improve failure detection with array parsing in pg_dump

2020-11-18 Thread Michael Paquier
Improve failure detection with array parsing in pg_dump Similarly to 3636efa, the checks done in pg_dump when parsing array values from catalogs have been too lax. Under memory pressure, it could be possible, though very unlikely, to finish with dumps that miss some data like: - Statistics for in

pgsql: Add BarrierArriveAndDetachExceptLast().

2020-11-18 Thread Thomas Munro
Add BarrierArriveAndDetachExceptLast(). Provide a way for one process to continue the remaining phases of a (previously) parallel computation alone. Later patches will use this to extend Parallel Hash Join. Author: Melanie Plageman Reviewed-by: Thomas Munro Discussion: https://postgr.es/m/CA%