Release date: 2020-05-29
This release contains a variety of improvements over PostgreSQL 12.3. For more information about new features in the core 12.3 release, see Section E.42.
A dump/restore is not required for those running 12.X.
Avoid taking a new snapshot for an immutable simple expression in plpgsql.
We already used this optimization if the plpgsql function is read-only. But it seems okay to do it even in a read-write function, if the expression contains only immutable functions/operators. The benefits are significant for simple cases with net performance improvements around 45%. Backpatch from community PG master.
Add a new pg2q.backtrace_on_internal_error configuration parameter
The new option, if set, will also output the backtrace information (if available) in the logs. Note that this is done only for ERRCODE_INTERNAL_ERROR category of errors.