E.18. 2ndQuadrant Postgres 12.3r1.1.1

E.18.1. Migration
E.18.2. Changes

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.36.

E.18.1. Migration

A dump/restore is not required for those running 12.X.

E.18.2. Changes

  • 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.