Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time

On 17th of January 2021, Magnus Hagander committed patch: Add pg_stat_database counters for sessions and session time   This add counters for number of sessions, the different kind of session termination types, and timers for how much time is spent in active vs idle in a database to pg_stat_database.   Internally this also renames the … Continue reading “Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time”

Waiting for PostgreSQL 14 – Add idle_session_timeout.

On 6th of January 2021, Tom Lane committed patch: Add idle_session_timeout.   This GUC variable works much like idle_in_transaction_session_timeout, in that it kills sessions that have waited too long for a new client query. But it applies when we’re not in a transaction, rather than when we are.   Li Japin, reviewed by David Johnston … Continue reading “Waiting for PostgreSQL 14 – Add idle_session_timeout.”

Waiting for PostgreSQL 14 – Report progress of COPY commands

On 6th of January 2021, Tomas Vondra committed patch: Report progress of COPY commands   This commit introduces a view pg_stat_progress_copy, reporting progress of COPY commands. This allows rough estimates how far a running COPY progressed, with the caveat that the total number of bytes may not be available in some cases (e.g. when the … Continue reading “Waiting for PostgreSQL 14 – Report progress of COPY commands”

Waiting for PostgreSQL 14 – Multirange datatypes

On 20th of December 2020, Alexander Korotkov committed patch: Multirange datatypes   Multiranges are basically sorted arrays of non-overlapping ranges with set-theoretic operations defined over them.   Since v14, each range type automatically gets a corresponding multirange datatype. There are both manual and automatic mechanisms for naming multirange types. Once can specify multirange type name … Continue reading “Waiting for PostgreSQL 14 – Multirange datatypes”

Waiting for PostgreSQL 14 – pg_stat_statements: Track time at which all statistics were last reset.

On 18th of December 2020, Fujii Masao committed patch: pg_stat_statements: Track time at which all statistics were last reset.   This commit adds "stats_reset" column into the pg_stat_statements_info view. This column indicates the time at which all statistics in the pg_stat_statements view were last reset.   Per discussion, this commit also changes pg_stat_statements_info code so … Continue reading “Waiting for PostgreSQL 14 – pg_stat_statements: Track time at which all statistics were last reset.”

Waiting for PostgreSQL 14 – Allow subscripting of hstore values.

On 11st of December 2020, Tom Lane committed patch: Allow subscripting of hstore values.   This is basically a finger exercise to prove that it’s possible for an extension module to add subscripting ability. Subscripted fetch from an hstore is not different from the existing "hstore -> text" operator. Subscripted update does seem to be … Continue reading “Waiting for PostgreSQL 14 – Allow subscripting of hstore values.”

Waiting for PostgreSQL 14 – Provide the OR REPLACE option for CREATE TRIGGER.

On 14th of November 2020, Tom Lane committed patch: Provide the OR REPLACE option for CREATE TRIGGER.   This is mostly straightforward. However, we disallow replacing constraint triggers or changing the is-constraint property; perhaps that can be added later, but the complexity versus benefit tradeoff doesn’t look very good.   Also, no special thought is … Continue reading “Waiting for PostgreSQL 14 – Provide the OR REPLACE option for CREATE TRIGGER.”

Waiting for PostgreSQL 14 – Support negative indexes in split_part().

On 13rd of November 2020, Tom Lane committed patch: Support negative indexes in split_part().   This provides a handy way to get, say, the last field of the string. Use of a negative index in this way has precedent in the nearby left() and right() functions.   The implementation scans the string twice when N … Continue reading “Waiting for PostgreSQL 14 – Support negative indexes in split_part().”

Waiting for PostgreSQL 14 – Support for OUT parameters in procedures

On 5th of October 2020, Peter Eisentraut committed patch: Support for OUT parameters in procedures   Unlike for functions, OUT parameters for procedures are part of the signature. Therefore, they have to be listed in pg_proc.proargtypes as well as mentioned in ALTER PROCEDURE and DROP PROCEDURE.   Reviewed-by: Andrew Dunstan <andrew.dunstan@2ndquadrant.com> Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com> … Continue reading “Waiting for PostgreSQL 14 – Support for OUT parameters in procedures”

Waiting for PostgreSQL 13 – psql: Display stats target of extended statistics

On 11st of September 2020, Alvaro Herrera committed patch: psql: Display stats target of extended statistics   The stats target can be set since commit d06215d03, but wasn’t shown by psql.   Author: Justin Pryzby <justin@telsasoft.com> Discussion: https://postgr.es/m/20200831050047.GG5450@telsasoft.com Reviewed-by: Georgios Kokolatos <gkokolatos@protonmail.com> Reviewed-by: Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>