On 1st of February 2021, Peter Eisentraut committed patch: SEARCH and CYCLE clauses This adds the SQL standard feature that adds the SEARCH and CYCLE clauses to recursive queries to be able to do produce breadth- or depth-first search orders and detect cycles. These clauses can be rewritten into queries using existing syntax, and … Continue reading “Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses”
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”
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.”
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”
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”
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.”
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.”
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.”
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().”
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”