corpus.blog
56,966 blogs · [ { "id": "01a07df2-9197-73b9-a987-1061a881a623", "title": "New things for regular expressions in PostgreSQL (pg_tre and pg_re2)", "url": "https://www.depesz.com/2026/08/25/new-things-for-regular-expressions-in-postgresql-pg_tre-and-pg_re2/", "published_at": "2026-08-25T18:41:53+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061a8ffc541", "title": "Waiting for PostgreSQL 19 – SQL Property Graph Queries (SQL/PGQ)", "url": "https://www.depesz.com/2026/07/31/waiting-for-postgresql-19-sql-property-graph-queries-sql-pgq/", "published_at": "2026-07-31T16:57:44+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061a96d0ea8", "title": "Waiting for PostgreSQL 20 – Add min() and max() aggregate support for uuid.", "url": "https://www.depesz.com/2026/07/09/waiting-for-postgresql-20-add-min-and-max-aggregate-support-for-uuid/", "published_at": "2026-07-09T12:41:14+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061a9f50bec", "title": "Waiting for PostgreSQL 20 – Add backend-level lock statistics", "url": "https://www.depesz.com/2026/07/06/waiting-for-postgresql-20-add-backend-level-lock-statistics/", "published_at": "2026-07-06T17:30:55+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061aab6c6fa", "title": "Posting explains from tools (and not web browsers)", "url": "https://www.depesz.com/2026/06/25/posting-explains-from-tools-and-not-web-browsers/", "published_at": "2026-06-25T14:56:17+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061ab67cbc4", "title": "Polish configuration for TSearch", "url": "https://www.depesz.com/2026/04/21/polish-configuration-for-tsearch/", "published_at": "2026-04-21T21:06:13+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061ab7c078a", "title": "Waiting for PostgreSQL 19 – Add CONCURRENTLY option to REPACK", "url": "https://www.depesz.com/2026/04/21/waiting-for-postgresql-19-add-concurrently-option-to-repack/", "published_at": "2026-04-21T10:40:14+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061ac38c841", "title": "Waiting for PostgreSQL 19 – Online enabling and disabling of data checksums", "url": "https://www.depesz.com/2026/04/15/waiting-for-postgresql-19-online-enabling-and-disabling-of-data-checksums/", "published_at": "2026-04-15T18:05:36+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061acd8a507", "title": "Waiting for PostgreSQL 19 – new pg_get_*_ddl() functions", "url": "https://www.depesz.com/2026/04/09/waiting-for-postgresql-19-new-pg_get__ddl-functions/", "published_at": "2026-04-09T16:37:45+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061ad811f03", "title": "Waiting for PostgreSQL 19 – Add UPDATE/DELETE FOR PORTION OF", "url": "https://www.depesz.com/2026/04/02/waiting-for-postgresql-19-add-update-delete-for-portion-of/", "published_at": "2026-04-02T10:51:21+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061add3c934", "title": "Waiting for PostgreSQL 19 – json format for COPY TO", "url": "https://www.depesz.com/2026/03/29/waiting-for-postgresql-19-json-format-for-copy-to/", "published_at": "2026-03-29T12:34:22+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061adf00eff", "title": "Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION.", "url": "https://www.depesz.com/2026/03/26/waiting-for-postgresql-19-add-support-for-except-table-in-alter-publication/", "published_at": "2026-03-26T11:46:24+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061aee1a12f", "title": "Waiting for PostgreSQL 19 – Add pg_plan_advice contrib module.", "url": "https://www.depesz.com/2026/03/22/waiting-for-postgresql-19-add-pg_plan_advice-contrib-module/", "published_at": "2026-03-22T13:44:10+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061afb79d95", "title": "Waiting for PostgreSQL 19 – Introduce the REPACK command", "url": "https://www.depesz.com/2026/03/19/waiting-for-postgresql-19-introduce-the-repack-command/", "published_at": "2026-03-19T18:07:59+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061afc00d1f", "title": "Waiting for PostgreSQL 19 – Allow table exclusions in publications via EXCEPT TABLE.", "url": "https://www.depesz.com/2026/03/18/waiting-for-postgresql-19-allow-table-exclusions-in-publications-via-except-table/", "published_at": "2026-03-18T11:15:16+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b0ab6dd8", "title": "Waiting for PostgreSQL 19 – Add non-text output formats to pg_dumpall", "url": "https://www.depesz.com/2026/03/17/waiting-for-postgresql-19-add-non-text-output-formats-to-pg_dumpall/", "published_at": "2026-03-17T10:29:38+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b147192f", "title": "Waiting for PostgreSQL 19 – Allow log_min_messages to be set per process type", "url": "https://www.depesz.com/2026/02/21/waiting-for-postgresql-19-allow-log_min_messages-to-be-set-per-process-type/", "published_at": "2026-02-21T19:05:27+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b1649d55", "title": "Waiting for PostgreSQL 19 – psql: Add %i prompt escape to indicate hot standby status.", "url": "https://www.depesz.com/2026/02/21/waiting-for-postgresql-19-psql-add-i-prompt-escape-to-indicate-hot-standby-status/", "published_at": "2026-02-21T14:51:47+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b254e613", "title": "Per-worker, and global, IO bandwidth in explain plans", "url": "https://www.depesz.com/2026/02/21/per-worker-and-global-io-bandwidth-in-explain-plans/", "published_at": "2026-02-21T13:24:57+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b3295cf8", "title": "How to render timestamp with a timezone that is different from current?", "url": "https://www.depesz.com/2026/01/27/how-to-render-timestamp-with-a-timezone-that-is-different-from-current/", "published_at": "2026-01-27T09:25:04+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b41babc5", "title": "Quick and dirty loading of CSV files", "url": "https://www.depesz.com/2026/01/07/quick-and-dirty-loading-of-csv-files/", "published_at": "2026-01-07T00:10:32+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b4f3dbc3", "title": "Small improvement for pretty-printing in paste.depesz.com", "url": "https://www.depesz.com/2026/01/06/improvement-for-pretty-printing-in-paste-depesz-com/", "published_at": "2026-01-06T15:13:10+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b53f39c5", "title": "What is index overhead on writes?", "url": "https://www.depesz.com/2026/01/06/what-is-index-overhead-on-writes/", "published_at": "2026-01-06T11:57:10+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b58ccd8c", "title": "Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE/SPLIT PARTITIONS … command", "url": "https://www.depesz.com/2026/01/04/waiting-for-postgresql-19-implement-alter-table-merge-split-partitions-command/", "published_at": "2026-01-04T17:30:47+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b66d2dec", "title": "Using JSON: json vs. jsonb, pglz vs. lz4, key optimization, parsing speed?", "url": "https://www.depesz.com/2025/11/29/using-json-json-vs-jsonb-pglz-vs-lz4-key-optimization-parsing-speed/", "published_at": "2025-11-29T19:16:00+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b6b10b25", "title": "Waiting for PostgreSQL 19 – Sequence synchronization in logical replication.", "url": "https://www.depesz.com/2025/11/11/waiting-for-postgresql-19-sequence-synchronization-in-logical-replication/", "published_at": "2025-11-11T12:24:23+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b7519308", "title": "Do you really need tsvector column?", "url": "https://www.depesz.com/2025/11/03/do-you-really-need-tsvector-column/", "published_at": "2025-11-03T12:34:33+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b7e5da15", "title": "Waiting for PostgreSQL 19 – Add psql PROMPT variable for search_path.", "url": "https://www.depesz.com/2025/10/29/waiting-for-postgresql-19-add-psql-prompt-variable-for-search_path/", "published_at": "2025-10-29T11:59:17+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b8cbbeb5", "title": "Waiting for PostgreSQL 19 – Support COPY TO for partitioned tables.", "url": "https://www.depesz.com/2025/10/22/waiting-for-postgresql-19-support-copy-to-for-partitioned-tables/", "published_at": "2025-10-22T10:05:08+00:00" }, { "id": "01a07df2-9197-73b9-a987-1061b9468003", "title": "Waiting for PostgreSQL 19 – Add IGNORE NULLS/RESPECT NULLS option to Window functions.", "url": "https://www.depesz.com/2025/10/13/waiting-for-postgresql-19-add-ignore-nulls-respect-nulls-option-to-window-functions/", "published_at": "2025-10-13T11:13:52+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e2719d72d5b", "title": "Waiting for PostgreSQL 19 – Add GROUP BY ALL.", "url": "https://www.depesz.com/2025/10/02/waiting-for-postgresql-19-add-group-by-all/", "published_at": "2025-10-02T06:56:41+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e271a6e0c57", "title": "vtime – time commands with elapsed time visible all the time", "url": "https://www.depesz.com/2025/10/01/vtime-time-commands-with-elapsed-time-visible-all-the-time/", "published_at": "2025-10-01T14:54:33+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e271b203c88", "title": "Waiting for PostgreSQL 19 – Add date and timestamp variants of random(min, max).", "url": "https://www.depesz.com/2025/09/17/waiting-for-postgresql-19-add-date-and-timestamp-variants-of-randommin-max/", "published_at": "2025-09-17T15:18:50+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e271b8b13af", "title": "Who logged to system from multiple countries in 2 hours?", "url": "https://www.depesz.com/2025/08/29/who-logged-to-system-from-multiple-countries-in-2-hours/", "published_at": "2025-08-29T08:15:05+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e271c4cf838", "title": "Waiting for PostgreSQL 19 – Display Memoize planner estimates in EXPLAIN", "url": "https://www.depesz.com/2025/08/04/waiting-for-postgresql-19-display-memoize-planner-estimates-in-explain/", "published_at": "2025-08-04T08:02:01+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e271ca86c87", "title": "pg_dump speed across versions", "url": "https://www.depesz.com/2025/05/22/pg_dump-speed-across-versions/", "published_at": "2025-05-22T07:44:20+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e271d88b545", "title": "Waiting for PostgreSQL 18 – Add function to get memory context stats for processes", "url": "https://www.depesz.com/2025/05/05/waiting-for-postgresql-18-add-function-to-get-memory-context-stats-for-processes/", "published_at": "2025-05-05T13:14:56+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e271e310aeb", "title": "Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALID", "url": "https://www.depesz.com/2025/05/01/waiting-for-postgresql-18-allow-not-null-constraints-to-be-added-as-not-valid/", "published_at": "2025-05-01T10:55:08+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e271f1b287a", "title": "Waiting for PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto.", "url": "https://www.depesz.com/2025/04/17/waiting-for-postgresql-18-add-modern-sha-2-based-password-hashes-to-pgcrypto/", "published_at": "2025-04-17T10:44:08+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e271fc8f646", "title": "Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore", "url": "https://www.depesz.com/2025/04/15/waiting-for-postgresql-18-non-text-modes-for-pg_dumpall-correspondingly-change-pg_restore/", "published_at": "2025-04-15T10:46:32+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27206b50f3", "title": "Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elements", "url": "https://www.depesz.com/2025/03/13/waiting-for-postgresql-18-allow-jsonb_strip_nulls-to-remove-null-array-elements/", "published_at": "2025-03-13T06:24:33+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27206fe962", "title": "Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexes", "url": "https://www.depesz.com/2025/03/11/waiting-for-postgresql-18-allow-parallel-create-index-for-gin-indexes/", "published_at": "2025-03-11T13:06:46+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27208659e2", "title": "Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.", "url": "https://www.depesz.com/2025/02/28/waiting-for-postgresql-18-allow-explain-to-indicate-fractional-rows/", "published_at": "2025-02-28T18:19:36+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27210e039f", "title": "Waiting for PostgreSQL 18 – Virtual generated columns", "url": "https://www.depesz.com/2025/02/28/waiting-for-postgresql-18-virtual-generated-columns/", "published_at": "2025-02-28T12:44:01+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e2721fcf5bb", "title": "Waiting for PostgreSQL 18 – Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs.", "url": "https://www.depesz.com/2025/02/19/waiting-for-postgresql-18-add-delay-time-to-vacuum-analyze-verbose-and-autovacuum-logs/", "published_at": "2025-02-19T11:40:10+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e2722ae8483", "title": "Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.", "url": "https://www.depesz.com/2025/02/13/waiting-for-postgresql-18-add-cost-based-vacuum-delay-time-to-progress-views/", "published_at": "2025-02-13T17:57:02+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27230b42d0", "title": "Waiting for PostgreSQL 18 – Support RN (roman-numeral format) in to_number().", "url": "https://www.depesz.com/2025/02/09/waiting-for-postgresql-18-support-rn-roman-numeral-format-in-to_number/", "published_at": "2025-02-09T07:59:46+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27237b63fc", "title": "Waiting for PostgreSQL 18 – Add OLD/NEW support to RETURNING in DML queries.", "url": "https://www.depesz.com/2025/01/30/waiting-for-postgresql-18-add-old-new-support-to-returning-in-dml-queries/", "published_at": "2025-01-30T10:45:26+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27246c493c", "title": "Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting.", "url": "https://www.depesz.com/2025/01/24/waiting-for-postgresql-18-allow-changing-autovacuum_max_workers-without-restarting/", "published_at": "2025-01-24T10:16:16+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e2724f97400", "title": "Waiting for PostgreSQL 18 – Enable BUFFERS with EXPLAIN ANALYZE by default", "url": "https://www.depesz.com/2025/01/15/waiting-for-postgresql-18-enable-buffers-with-explain-analyze-by-default/", "published_at": "2025-01-15T19:53:18+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27250685a1", "title": "Waiting for PostgreSQL 18 – Support LIKE with nondeterministic collations", "url": "https://www.depesz.com/2025/01/10/waiting-for-postgresql-18-support-like-with-nondeterministic-collations/", "published_at": "2025-01-10T17:02:52+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e2725c9beb3", "title": "Waiting for PostgreSQL 18 – psql: Add more information about service name", "url": "https://www.depesz.com/2025/01/06/waiting-for-postgresql-18-psql-add-more-information-about-service-name/", "published_at": "2025-01-06T09:43:37+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27266d85d4", "title": "Waiting for PostgreSQL 18 – Add UUID version 7 generation function.", "url": "https://www.depesz.com/2024/12/31/waiting-for-postgresql-18-add-uuid-version-7-generation-function/", "published_at": "2024-12-31T09:37:04+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e272761ac2b", "title": "How to ALTER tables without breaking application?", "url": "https://www.depesz.com/2024/12/12/how-to-alter-tables-without-breaking-application/", "published_at": "2024-12-12T14:15:24+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e2727c22a78", "title": "SQL best practices – don’t compare count(*) with 0", "url": "https://www.depesz.com/2024/12/01/sql-best-practices-dont-compare-count-with-0/", "published_at": "2024-12-01T09:21:57+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e27287e4218", "title": "How can I send mail or HTTP request from database?", "url": "https://www.depesz.com/2024/11/25/how-can-i-send-mail-or-http-request-from-database/", "published_at": "2024-11-25T22:45:34+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e272972b78a", "title": "Changes on pgdoc.link", "url": "https://www.depesz.com/2024/11/22/changes-on-pgdoc-link/", "published_at": "2024-11-22T14:24:41+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e2729ffb291", "title": "Grouping data into array of sums – fun with custom aggregates", "url": "https://www.depesz.com/2024/11/15/grouping-data-into-array-of-sums-fun-with-custom-aggregates/", "published_at": "2024-11-15T14:55:58+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e272a1e3806", "title": "System views added to pgdoc.link", "url": "https://www.depesz.com/2024/11/06/system-views-added-to-pgdoc-link/", "published_at": "2024-11-06T11:44:53+00:00" }, { "id": "01a0c507-5c84-71f9-91c5-6e272a5cd218", "title": "Waiting for PostgreSQL 18 – Add SQL function array_reverse()", "url": "https://www.depesz.com/2024/11/05/waiting-for-postgresql-18-add-sql-function-array_reverse/", "published_at": "2024-11-05T08:17:35+00:00" }, { "id": "01a0c518-3705-7273-9a29-689722e5ef8b", "title": "New way to search PostgreSQL documentation", "url": "https://www.depesz.com/2024/10/29/new-way-to-search-postgresql-documentation/", "published_at": "2024-10-29T10:45:23+00:00" }, { "id": "01a0c518-3705-7273-9a29-689723223f58", "title": "Case study: optimization of weirdly picked bad plan", "url": "https://www.depesz.com/2024/10/28/case-study-optimization-of-weirdly-picked-bad-plan/", "published_at": "2024-10-28T12:04:44+00:00" }, { "id": "01a0c518-3705-7273-9a29-689723d5db3d", "title": "SQL/JSON is here! (kinda “Waiting for Pg 17”)", "url": "https://www.depesz.com/2024/10/11/sql-json-is-here-kinda-waiting-for-pg-17/", "published_at": "2024-10-11T21:37:40+00:00" }, { "id": "01a0c518-3705-7273-9a29-6897243cf313", "title": "Waiting for PostgreSQL 18 – Add temporal FOREIGN KEY contraints", "url": "https://www.depesz.com/2024/10/03/waiting-for-postgresql-18-add-temporal-foreign-key-contraints/", "published_at": "2024-10-03T18:19:03+00:00" }, { "id": "01a0c518-3705-7273-9a29-6897245035b3", "title": "Waiting for PostgreSQL 18 – Add temporal PRIMARY KEY and UNIQUE constraints", "url": "https://www.depesz.com/2024/09/30/waiting-for-postgresql-18-add-temporal-primary-key-and-unique-constraints/", "published_at": "2024-09-30T10:19:09+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972514e719", "title": "What tables were touched within given range of wal LSN?", "url": "https://www.depesz.com/2024/07/19/what-tables-were-touched-within-given-range-of-wal-lsn/", "published_at": "2024-07-19T15:00:09+00:00" }, { "id": "01a0c518-3705-7273-9a29-689725422ea1", "title": "How much speed you’re leaving at the table if you use default locale?", "url": "https://www.depesz.com/2024/06/11/how-much-speed-youre-leaving-at-the-table-if-you-use-default-locale/", "published_at": "2024-06-11T18:53:35+00:00" }, { "id": "01a0c518-3705-7273-9a29-689725fc5400", "title": "Waiting for PostgreSQL 17 – MERGE / SPLIT partitions", "url": "https://www.depesz.com/2024/05/22/waiting-for-postgresql-17-merge-split-partitions/", "published_at": "2024-05-22T11:41:42+00:00" }, { "id": "01a0c518-3705-7273-9a29-689726553968", "title": "Waiting for …: SQL/JSON is coming back. Hopefully.", "url": "https://www.depesz.com/2024/04/12/waiting-for-sql-json-is-coming-back-hopefully/", "published_at": "2024-04-12T11:28:05+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972668a977", "title": "Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN.", "url": "https://www.depesz.com/2024/04/11/waiting-for-postgresql-17-invent-serialize-option-for-explain/", "published_at": "2024-04-11T19:51:35+00:00" }, { "id": "01a0c518-3705-7273-9a29-689727329161", "title": "Waiting for PostgreSQL 17 – Add new COPY option LOG_VERBOSITY.", "url": "https://www.depesz.com/2024/04/11/waiting-for-postgresql-17-add-new-copy-option-log_verbosity/", "published_at": "2024-04-11T19:38:06+00:00" }, { "id": "01a0c518-3705-7273-9a29-6897278d1b59", "title": "Waiting for PostgreSQL 17 – Add support for MERGE … WHEN NOT MATCHED BY SOURCE.", "url": "https://www.depesz.com/2024/04/11/waiting-for-postgresql-17-add-support-for-merge-when-not-matched-by-source/", "published_at": "2024-04-11T19:26:31+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972819ffdc", "title": "Waiting for PostgreSQL 17 – Add RETURNING support to MERGE.", "url": "https://www.depesz.com/2024/03/19/waiting-for-postgresql-17-add-returning-support-to-merge/", "published_at": "2024-03-19T18:41:48+00:00" }, { "id": "01a0c518-3705-7273-9a29-689728b98e23", "title": "What the hell is transaction wraparound?", "url": "https://www.depesz.com/2024/03/18/what-the-hell-is-transaction-wraparound/", "published_at": "2024-03-18T10:59:55+00:00" }, { "id": "01a0c518-3705-7273-9a29-689729a0f859", "title": "Waiting for PostgreSQL 17 – Add new COPY option SAVE_ERROR_TO / Rename COPY option from SAVE_ERROR_TO to ON_ERROR", "url": "https://www.depesz.com/2024/02/07/waiting-for-postgresql-17-add-new-copy-option-save_error_to-rename-copy-option-from-save_error_to-to-on_error/", "published_at": "2024-02-07T21:41:37+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972a8d2bac", "title": "Waiting for PostgreSQL 17 – Support identity columns in partitioned tables", "url": "https://www.depesz.com/2024/02/07/waiting-for-postgresql-17-support-identity-columns-in-partitioned-tables/", "published_at": "2024-02-07T20:12:08+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972b116ce3", "title": "Waiting for PostgreSQL 17 – In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration.", "url": "https://www.depesz.com/2024/01/22/waiting-for-postgresql-17-in-plpgsql-allow-type-and-rowtype-to-be-followed-by-array-decoration/", "published_at": "2024-01-22T11:36:38+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972bfeb550", "title": "Waiting for PostgreSQL 17 – ALTER TABLE command to change generation expression", "url": "https://www.depesz.com/2024/01/15/waiting-for-postgresql-17-alter-table-command-to-change-generation-expression/", "published_at": "2024-01-15T15:30:01+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972c23bedc", "title": "Waiting for PostgreSQL 17 – Add support for incremental backup.", "url": "https://www.depesz.com/2024/01/08/waiting-for-postgresql-17-add-support-for-incremental-backup/", "published_at": "2024-01-08T18:23:52+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972c4c73d1", "title": "Proper support for I/O Timings on explain.depesz.com", "url": "https://www.depesz.com/2023/12/29/proper-support-for-i-o-timings-on-explain-depesz-com/", "published_at": "2023-12-29T12:20:55+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972c78c8a8", "title": "Human/version sort in PostgreSQL – revisited", "url": "https://www.depesz.com/2023/10/24/human-version-sort-in-postgresql-revisited/", "published_at": "2023-10-24T21:37:19+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972d732446", "title": "Waiting for PostgreSQL 17 – Add support event triggers on authenticated login", "url": "https://www.depesz.com/2023/10/24/waiting-for-postgresql-17-add-support-event-triggers-on-authenticated-login/", "published_at": "2023-10-24T13:19:19+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972dbbd4f1", "title": "Waiting for PostgreSQL 17 – Allow \\watch queries to stop on minimum rows returned", "url": "https://www.depesz.com/2023/09/07/waiting-for-postgresql-17-allow-watch-queries-to-stop-on-minimum-rows-returned/", "published_at": "2023-09-07T10:47:46+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972e14bacc", "title": "Waiting for PostgreSQL 17 – Generate new LOG for “trust” connections under log_connections", "url": "https://www.depesz.com/2023/09/01/waiting-for-postgresql-17-generate-new-log-for-trust-connections-under-log_connections/", "published_at": "2023-09-01T21:44:04+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972e3b8188", "title": "Waiting for PostgreSQL 17 – Add to_bin() and to_oct().", "url": "https://www.depesz.com/2023/09/01/waiting-for-postgresql-17-add-to_bin-and-to_oct/", "published_at": "2023-09-01T13:27:50+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972e9351a5", "title": "Human/version sort in PostgreSQL", "url": "https://www.depesz.com/2023/07/28/human-version-sort-in-postgresql/", "published_at": "2023-07-28T10:14:44+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972ec64708", "title": "Why is my WAL directory so large?", "url": "https://www.depesz.com/2023/06/18/why-is-my-wal-directory-so-large/", "published_at": "2023-06-18T08:50:02+00:00" }, { "id": "01a0c518-3705-7273-9a29-68972f2e6aa2", "title": "A tale about (incomplete) upgrade from PostgreSQL 12 to 14", "url": "https://www.depesz.com/2023/06/04/a-tale-about-incomplete-upgrade-from-postgresql-12-to-14/", "published_at": "2023-06-04T14:48:11+00:00" }, { "id": "01a0c518-3705-7273-9a29-689730075054", "title": "Variables in psql, how to use them?", "url": "https://www.depesz.com/2023/05/28/variables-in-psql-how-to-use-them/", "published_at": "2023-05-28T13:50:52+00:00" }, { "id": "01a0c518-3705-7273-9a29-68973034f971", "title": "Waiting for PostgreSQL 16 – Add array_sample() and array_shuffle() functions.", "url": "https://www.depesz.com/2023/04/18/waiting-for-postgresql-16-add-array_sample-and-array_shuffle-functions/", "published_at": "2023-04-18T15:22:51+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb6280a9010", "title": "System roles – what, why, how?", "url": "https://www.depesz.com/2023/03/14/system-roles-what-why-how/", "published_at": "2023-03-14T20:13:42+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb628cbbbc6", "title": "Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics", "url": "https://www.depesz.com/2023/02/27/waiting-for-postgresql-16-add-pg_stat_io-view-providing-more-detailed-io-statistics/", "published_at": "2023-02-27T15:50:01+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62969086c", "title": "How to get a row, and all of it’s dependencies?", "url": "https://www.depesz.com/2023/02/07/how-to-get-a-row-and-all-of-its-dependencies/", "published_at": "2023-02-07T10:15:57+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb629e621b5", "title": "Now you can \\d table not only in psql :)", "url": "https://www.depesz.com/2023/02/07/now-you-can-d-table-not-only-in-psql/", "published_at": "2023-02-07T00:37:20+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62a306e2d", "title": "When to use VACUUM FULL", "url": "https://www.depesz.com/2023/02/06/when-to-use-vacuum-full/", "published_at": "2023-02-06T20:35:20+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62ae27891", "title": "Waiting for PostgreSQL 16 – Allow underscores in integer and numeric constants.", "url": "https://www.depesz.com/2023/02/06/waiting-for-postgresql-16-allow-underscores-in-integer-and-numeric-constants/", "published_at": "2023-02-06T11:58:58+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62b1999b3", "title": "Can you use fzf for psql history?", "url": "https://www.depesz.com/2023/01/23/can-you-use-fzf-for-psql-history/", "published_at": "2023-01-23T16:00:15+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62bbf4af2", "title": "Waiting for PostgreSQL 16 – Invent random_normal() to provide normally-distributed random numbers.", "url": "https://www.depesz.com/2023/01/11/waiting-for-postgresql-16-invent-random_normal-to-provide-normally-distributed-random-numbers/", "published_at": "2023-01-11T16:19:39+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62c6fc921", "title": "Waiting for PostgreSQL 16 – Non-decimal integer literals", "url": "https://www.depesz.com/2022/12/14/waiting-for-postgresql-16-non-decimal-integer-literals/", "published_at": "2022-12-14T18:42:59+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62cccf03b", "title": "Waiting for PostgreSQL 16 – Add grantable MAINTAIN privilege and pg_maintain role.", "url": "https://www.depesz.com/2022/12/14/waiting-for-postgresql-16-add-grantable-maintain-privilege-and-pg_maintain-role/", "published_at": "2022-12-14T12:35:04+00:00" } ] posts Claim your blog
Back to Hubert Lubaczewski
Blog · corpus.blog/blogs/depesz.com/posts

Hubert Lubaczewski

depesz.com

2026

New things for regular expressions in PostgreSQL (pg_tre and pg_re2)original ↗
25 Aug 2026
Waiting for PostgreSQL 19 – SQL Property Graph Queries (SQL/PGQ)original ↗
31 Jul 2026
Waiting for PostgreSQL 20 – Add min() and max() aggregate support for uuid.original ↗
9 Jul 2026
Waiting for PostgreSQL 20 – Add backend-level lock statisticsoriginal ↗
6 Jul 2026
Posting explains from tools (and not web browsers)original ↗
25 Jun 2026
Polish configuration for TSearchoriginal ↗
21 Apr 2026
Waiting for PostgreSQL 19 – Add CONCURRENTLY option to REPACKoriginal ↗
21 Apr 2026
Waiting for PostgreSQL 19 – Online enabling and disabling of data checksumsoriginal ↗
15 Apr 2026
Waiting for PostgreSQL 19 – new pg_get_*_ddl() functionsoriginal ↗
9 Apr 2026
Waiting for PostgreSQL 19 – Add UPDATE/DELETE FOR PORTION OForiginal ↗
2 Apr 2026
Waiting for PostgreSQL 19 – json format for COPY TOoriginal ↗
29 Mar 2026
Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION.original ↗
26 Mar 2026
Waiting for PostgreSQL 19 – Add pg_plan_advice contrib module.original ↗
22 Mar 2026
Waiting for PostgreSQL 19 – Introduce the REPACK commandoriginal ↗
19 Mar 2026
Waiting for PostgreSQL 19 – Allow table exclusions in publications via EXCEPT TABLE.original ↗
18 Mar 2026
Waiting for PostgreSQL 19 – Add non-text output formats to pg_dumpalloriginal ↗
17 Mar 2026
Waiting for PostgreSQL 19 – Allow log_min_messages to be set per process typeoriginal ↗
21 Feb 2026
Waiting for PostgreSQL 19 – psql: Add %i prompt escape to indicate hot standby status.original ↗
21 Feb 2026
Per-worker, and global, IO bandwidth in explain plansoriginal ↗
21 Feb 2026
How to render timestamp with a timezone that is different from current?original ↗
27 Jan 2026
Quick and dirty loading of CSV filesoriginal ↗
7 Jan 2026
Small improvement for pretty-printing in paste.depesz.comoriginal ↗
6 Jan 2026
What is index overhead on writes?original ↗
6 Jan 2026
Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE/SPLIT PARTITIONS … commandoriginal ↗
4 Jan 2026

2025

Using JSON: json vs. jsonb, pglz vs. lz4, key optimization, parsing speed?original ↗
29 Nov 2025
Waiting for PostgreSQL 19 – Sequence synchronization in logical replication.original ↗
11 Nov 2025
Do you really need tsvector column?original ↗
3 Nov 2025
Waiting for PostgreSQL 19 – Add psql PROMPT variable for search_path.original ↗
29 Oct 2025
Waiting for PostgreSQL 19 – Support COPY TO for partitioned tables.original ↗
22 Oct 2025
Waiting for PostgreSQL 19 – Add IGNORE NULLS/RESPECT NULLS option to Window functions.original ↗
13 Oct 2025
Waiting for PostgreSQL 19 – Add GROUP BY ALL.original ↗
2 Oct 2025
vtime – time commands with elapsed time visible all the timeoriginal ↗
1 Oct 2025
Waiting for PostgreSQL 19 – Add date and timestamp variants of random(min, max).original ↗
17 Sept 2025
Who logged to system from multiple countries in 2 hours?original ↗
29 Aug 2025
Waiting for PostgreSQL 19 – Display Memoize planner estimates in EXPLAINoriginal ↗
4 Aug 2025
pg_dump speed across versionsoriginal ↗
22 May 2025
Waiting for PostgreSQL 18 – Add function to get memory context stats for processesoriginal ↗
5 May 2025
Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALIDoriginal ↗
1 May 2025
Waiting for PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto.original ↗
17 Apr 2025
Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restoreoriginal ↗
15 Apr 2025
Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elementsoriginal ↗
13 Mar 2025
Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexesoriginal ↗
11 Mar 2025
Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.original ↗
28 Feb 2025
Waiting for PostgreSQL 18 – Virtual generated columnsoriginal ↗
28 Feb 2025
Waiting for PostgreSQL 18 – Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs.original ↗
19 Feb 2025
Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.original ↗
13 Feb 2025
Waiting for PostgreSQL 18 – Support RN (roman-numeral format) in to_number().original ↗
9 Feb 2025
Waiting for PostgreSQL 18 – Add OLD/NEW support to RETURNING in DML queries.original ↗
30 Jan 2025
Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting.original ↗
24 Jan 2025
Waiting for PostgreSQL 18 – Enable BUFFERS with EXPLAIN ANALYZE by defaultoriginal ↗
15 Jan 2025
Waiting for PostgreSQL 18 – Support LIKE with nondeterministic collationsoriginal ↗
10 Jan 2025
Waiting for PostgreSQL 18 – psql: Add more information about service nameoriginal ↗
6 Jan 2025

2024

Waiting for PostgreSQL 18 – Add UUID version 7 generation function.original ↗
31 Dec 2024
How to ALTER tables without breaking application?original ↗
12 Dec 2024
SQL best practices – don’t compare count(*) with 0original ↗
1 Dec 2024
How can I send mail or HTTP request from database?original ↗
25 Nov 2024
Changes on pgdoc.linkoriginal ↗
22 Nov 2024
Grouping data into array of sums – fun with custom aggregatesoriginal ↗
15 Nov 2024
System views added to pgdoc.linkoriginal ↗
6 Nov 2024
Waiting for PostgreSQL 18 – Add SQL function array_reverse()original ↗
5 Nov 2024
New way to search PostgreSQL documentationoriginal ↗
29 Oct 2024
Case study: optimization of weirdly picked bad planoriginal ↗
28 Oct 2024
SQL/JSON is here! (kinda “Waiting for Pg 17”)original ↗
11 Oct 2024
Waiting for PostgreSQL 18 – Add temporal FOREIGN KEY contraintsoriginal ↗
3 Oct 2024
Waiting for PostgreSQL 18 – Add temporal PRIMARY KEY and UNIQUE constraintsoriginal ↗
30 Sept 2024
What tables were touched within given range of wal LSN?original ↗
19 Jul 2024
How much speed you’re leaving at the table if you use default locale?original ↗
11 Jun 2024
Waiting for PostgreSQL 17 – MERGE / SPLIT partitionsoriginal ↗
22 May 2024
Waiting for …: SQL/JSON is coming back. Hopefully.original ↗
12 Apr 2024
Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN.original ↗
11 Apr 2024
Waiting for PostgreSQL 17 – Add new COPY option LOG_VERBOSITY.original ↗
11 Apr 2024
Waiting for PostgreSQL 17 – Add support for MERGE … WHEN NOT MATCHED BY SOURCE.original ↗
11 Apr 2024
Waiting for PostgreSQL 17 – Add RETURNING support to MERGE.original ↗
19 Mar 2024
What the hell is transaction wraparound?original ↗
18 Mar 2024
Waiting for PostgreSQL 17 – Add new COPY option SAVE_ERROR_TO / Rename COPY option from SAVE_ERROR_TO to ON_ERRORoriginal ↗
7 Feb 2024
Waiting for PostgreSQL 17 – Support identity columns in partitioned tablesoriginal ↗
7 Feb 2024
Waiting for PostgreSQL 17 – In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration.original ↗
22 Jan 2024
Waiting for PostgreSQL 17 – ALTER TABLE command to change generation expressionoriginal ↗
15 Jan 2024
Waiting for PostgreSQL 17 – Add support for incremental backup.original ↗
8 Jan 2024

2023

Proper support for I/O Timings on explain.depesz.comoriginal ↗
29 Dec 2023
Human/version sort in PostgreSQL – revisitedoriginal ↗
24 Oct 2023
Waiting for PostgreSQL 17 – Add support event triggers on authenticated loginoriginal ↗
24 Oct 2023
Waiting for PostgreSQL 17 – Allow \watch queries to stop on minimum rows returnedoriginal ↗
7 Sept 2023
Waiting for PostgreSQL 17 – Generate new LOG for “trust” connections under log_connectionsoriginal ↗
1 Sept 2023
Waiting for PostgreSQL 17 – Add to_bin() and to_oct().original ↗
1 Sept 2023
Human/version sort in PostgreSQLoriginal ↗
28 Jul 2023
Why is my WAL directory so large?original ↗
18 Jun 2023
A tale about (incomplete) upgrade from PostgreSQL 12 to 14original ↗
4 Jun 2023
Variables in psql, how to use them?original ↗
28 May 2023
Waiting for PostgreSQL 16 – Add array_sample() and array_shuffle() functions.original ↗
18 Apr 2023
System roles – what, why, how?original ↗
14 Mar 2023
Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statisticsoriginal ↗
27 Feb 2023
How to get a row, and all of it’s dependencies?original ↗
7 Feb 2023
Now you can \d table not only in psql :)original ↗
7 Feb 2023
When to use VACUUM FULLoriginal ↗
6 Feb 2023
Waiting for PostgreSQL 16 – Allow underscores in integer and numeric constants.original ↗
6 Feb 2023
Can you use fzf for psql history?original ↗
23 Jan 2023
Waiting for PostgreSQL 16 – Invent random_normal() to provide normally-distributed random numbers.original ↗
11 Jan 2023

2022

Waiting for PostgreSQL 16 – Non-decimal integer literalsoriginal ↗
14 Dec 2022
Waiting for PostgreSQL 16 – Add grantable MAINTAIN privilege and pg_maintain role.original ↗
14 Dec 2022
Next