Deschide articolul original într-un tab nou Schimbarea acestei opțiuni se aplică imediat și reîncarcă pagina.
LECTURA
Înapoi la articole →

select * from depesz;

www.depesz.com/feed/
Vizitează site-ul

Cel mai recent articol

Ultima verificare

Urmăritori 2 urmăritori
Articole: 31

  1. Old tech is sometimes better – a case study based on blogpost from Now-Next…

    (select * from depesz;)

    Some time ago I read this blogpost.

  2. New things for regular expressions in PostgreSQL (pg_tre and pg_re2)

    (select * from depesz;)

    Well, truth be told these are not all that new (couple of months), but I finally have gotten around to research it.

  3. Waiting for PostgreSQL 19 – SQL Property Graph Queries (SQL/PGQ)

    (select * from depesz;)

    On 16th of March 2026, Peter Eisentraut committed patch: SQL Property Graph Queries (SQL/PGQ) Implementation of SQL property graph queries, according to SQL/PGQ standard (ISO/IEC 9075-16:2023).

  4. Waiting for PostgreSQL 20 – Add min() and max() aggregate support for uuid.

    (select * from depesz;)

    On 1st of July 2026, Masahiko Sawada committed patch: Add min() and max() aggregate support for uuid.

  5. Waiting for PostgreSQL 20 – Add backend-level lock statistics

    (select * from depesz;)

    On 30th of June 2026, Michael Paquier committed patch: Add backend-level lock statistics This commit adds per-backend lock statistics, providing the same information as pg_stat_lock.

  6. Posting explains from tools (and not web browsers)

    (select * from depesz;)

    Some time ago (well, a month ago) someone called zam6ak reached to me and asked about extraction of delete_key from plans posted using tool, and not website.

  7. Polish configuration for TSearch

    (select * from depesz;)

    Some time ago someone posted on Reddit that they have problems adding Polish configuration to their PostgreSQL.

  8. Waiting for PostgreSQL 19 – Add CONCURRENTLY option to REPACK

    (select * from depesz;)

    On 6th of April 2026, Álvaro Herrera committed patch: Add CONCURRENTLY option to REPACK When this flag is specified, REPACK no longer acquires access-exclusive lock while the new copy of the table is being created; instead, it creates the initial copy und…

  9. Waiting for PostgreSQL 19 – Online enabling and disabling of data checksums

    (select * from depesz;)

    On 3rd of April 2026, Daniel Gustafsson committed patch: Online enabling and disabling of data checksums This allows data checksums to be enabled, or disabled, in a running cluster without restricting access to the cluster during processing.

  10. Waiting for PostgreSQL 19 – new pg_get_*_ddl() functions

    (select * from depesz;)

    On 5th of April 2026, Andrew Dunstan committed patch: Add pg_get_database_ddl() function Add a new SQL-callable function that returns the DDL statements needed to recreate a database.

  11. Waiting for PostgreSQL 19 – Add UPDATE/DELETE FOR PORTION OF

    (select * from depesz;)

    On 1st of April 2026, Peter Eisentraut committed patch: Add UPDATE/DELETE FOR PORTION OF This is an extension of the UPDATE and DELETE commands to do a "temporal update/delete" based on a range or multirange column.

  12. Waiting for PostgreSQL 19 – json format for COPY TO

    (select * from depesz;)

    On 20th of March 2026, Andrew Dunstan committed patch: json format for COPY TO This introduces the JSON format option for the COPY TO command, allowing users to export query results or table data directly as a stream of JSON objects (one per line, NDJSON…

  13. Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION.

    (select * from depesz;)

    On 20th of March 2026, Amit Kapila committed patch: Add support for EXCEPT TABLE in ALTER PUBLICATION.

  14. Waiting for PostgreSQL 19 – Add pg_plan_advice contrib module.

    (select * from depesz;)

    On 12nd of March 2026, Robert Haas committed patch: Add pg_plan_advice contrib module.

  15. Waiting for PostgreSQL 19 – Introduce the REPACK command

    (select * from depesz;)

    On 10th of March 2026, Álvaro Herrera committed patch: Introduce the REPACK command REPACK absorbs the functionality of VACUUM FULL and CLUSTER in a single command.

  16. Waiting for PostgreSQL 19 – Allow table exclusions in publications via EXCEPT TABLE.

    (select * from depesz;)

    On 4th of March 2026, Amit Kapila committed patch: Allow table exclusions in publications via EXCEPT TABLE.

  17. Waiting for PostgreSQL 19 – Add non-text output formats to pg_dumpall

    (select * from depesz;)

    On 26th of February 2026, Andrew Dunstan committed patch: Add non-text output formats to pg_dumpall pg_dumpall can now produce output in custom, directory, or tar formats in addition to plain text SQL scripts.

  18. Waiting for PostgreSQL 19 – Allow log_min_messages to be set per process type

    (select * from depesz;)

    On 9th of February 2026, Álvaro Herrera committed patch: Allow log_min_messages to be set per process type Change log_min_messages from being a single element to a comma-separated list of type:level elements, with 'type' representing a process type, and '…

  19. Waiting for PostgreSQL 19 – psql: Add %i prompt escape to indicate hot standby status.

    (select * from depesz;)

    On 3rd of February 2026, Fujii Masao committed patch: psql: Add %i prompt escape to indicate hot standby status.

  20. Per-worker, and global, IO bandwidth in explain plans

    (select * from depesz;)

    Jeremy Schneider suggested a change to how plans are displayed – adding another bit of information in case we have timing information for IO for explain node.

  21. How to render timestamp with a timezone that is different from current?

    (select * from depesz;)

    This question appeared on IRC, and while I wasn't there while it happened, it caught my eye: » Can I not render this with timezone offset: select ‘2026-01-09 04:35:46.9824-08'::timestamp with time zone at time zone ‘UTC'; » Returns ‘2026-01-09 12:35:46.98…

  22. Quick and dirty loading of CSV files

    (select * from depesz;)

    Back in September 2025, David Fetter asked on IRC, about a tool to quickly load CSV to database.

  23. Small improvement for pretty-printing in paste.depesz.com

    (select * from depesz;)

    As you maybe know, some time ago I made paste service, mostly to use for queries, or related text to share on IRC.

  24. What is index overhead on writes?

    (select * from depesz;)

    One of things people learn is that adding indexes isn't free.

  25. Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE/SPLIT PARTITIONS … command

    (select * from depesz;)

    On 14th of December 2025, Alexander Korotkov committed patch: Implement ALTER TABLE ...

  26. Using JSON: json vs. jsonb, pglz vs. lz4, key optimization, parsing speed?

    (select * from depesz;)

    Recently(ish) I had a conversation on one of PostgreSQL support chats (IRC, Slack, or Discord) about efficient storage of JSON data, which compression to use, which datatype.

  27. Waiting for PostgreSQL 19 – Sequence synchronization in logical replication.

    (select * from depesz;)

    First, on 9th of October 2025, Amit Kapila committed patch: Add "ALL SEQUENCES" support to publications.

  28. Do you really need tsvector column?

    (select * from depesz;)

    When using tsearch one usually, often, creates a tsvector column to put data in, and then create index on it.

  29. Waiting for PostgreSQL 19 – Add psql PROMPT variable for search_path.

    (select * from depesz;)

    On 28th of October 2025, Nathan Bossart committed patch: Add psql PROMPT variable for search_path.

  30. Waiting for PostgreSQL 19 – Support COPY TO for partitioned tables.

    (select * from depesz;)

    On 20th of October 2025, Masahiko Sawada committed patch: Support COPY TO for partitioned tables.

  31. Waiting for PostgreSQL 19 – Add IGNORE NULLS/RESPECT NULLS option to Window functions.

    (select * from depesz;)

    On 3rd of October 2025, Tatsuo Ishii committed patch: Add IGNORE NULLS/RESPECT NULLS option to Window functions.