corpus.blog
41554 blogs · [ { "id": "01a0c523-328a-7207-869f-bdb62cf7259a", "title": "Waiting for PostgreSQL 16 – Add test scaffolding for soft error reporting from input functions.", "url": "https://www.depesz.com/2022/12/12/waiting-for-postgresql-16-add-test-scaffolding-for-soft-error-reporting-from-input-functions/", "published_at": "2022-12-12T13:34:04+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62dcec54a", "title": "Picking random element, with weights", "url": "https://www.depesz.com/2022/11/30/picking-random-element-with-weights/", "published_at": "2022-11-30T14:37:11+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62e4a18d6", "title": "Run a command every “x seconds”", "url": "https://www.depesz.com/2022/11/22/run-a-command-every-x-seconds/", "published_at": "2022-11-22T14:43:26+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62ebc7d90", "title": "Waiting for PostgreSQL 16 – Add support for regexps on database and user entries in pg_hba.conf", "url": "https://www.depesz.com/2022/11/03/waiting-for-postgresql-16-add-support-for-regexps-on-database-and-user-entries-in-pg_hba-conf/", "published_at": "2022-11-03T19:02:19+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb62f5b06de", "title": "Prettify SQL queries from command line", "url": "https://www.depesz.com/2022/09/21/prettify-sql-queries-from-command-line/", "published_at": "2022-09-21T14:05:42+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb63049fe57", "title": "What is LATERAL, what is it for, and how can one use it?", "url": "https://www.depesz.com/2022/09/18/what-is-lateral-what-is-it-for-and-how-can-one-use-it/", "published_at": "2022-09-18T14:53:58+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb630f2e792", "title": "SQL/JSON is postponed", "url": "https://www.depesz.com/2022/09/02/sql-json-is-postponed/", "published_at": "2022-09-02T10:16:54+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb631c3e830", "title": "New SQL pretty printer – based on parsing, and not regexps", "url": "https://www.depesz.com/2022/08/31/new-sql-pretty-printer-based-on-parsing-and-not-regexps/", "published_at": "2022-08-31T11:41:52+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb631d3c143", "title": "Better scrolling of long explain plans on explain.depesz.com", "url": "https://www.depesz.com/2022/07/12/better-scrolling-of-long-explain-plans-on-explain-depesz-com/", "published_at": "2022-07-12T11:52:40+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb632ccb3be", "title": "Understanding pg_stat_activity", "url": "https://www.depesz.com/2022/07/05/understanding-pg_stat_activity/", "published_at": "2022-07-05T01:59:24+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb633167573", "title": "How to log selects from specific table?", "url": "https://www.depesz.com/2022/07/04/how-to-log-selects-from-specific-table/", "published_at": "2022-07-04T12:40:18+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb6340ee91b", "title": "Stop the war in Ukraine", "url": "https://www.depesz.com/2022/04/12/stop-the-war-in-ukraine/", "published_at": "2022-04-12T09:59:34+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb6349981fb", "title": "Waiting for PostgreSQL 15 – Documentation for SQL/JSON features", "url": "https://www.depesz.com/2022/04/08/waiting-for-postgresql-15-documentation-for-sql-json-features/", "published_at": "2022-04-08T10:53:40+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb634ed0c67", "title": "Waiting for PostgreSQL 15 – JSON_TABLE", "url": "https://www.depesz.com/2022/04/06/waiting-for-postgresql-15-json_table/", "published_at": "2022-04-06T17:40:42+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb6354e2e58", "title": "DBA tips ‘n tricks – search in every field in a table", "url": "https://www.depesz.com/2022/04/05/dba-tips-n-tricks-search-in-every-field-in-a-table/", "published_at": "2022-04-05T12:53:53+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb635be8256", "title": "Waiting for PostgreSQL 15 – SQL/JSON query functions", "url": "https://www.depesz.com/2022/04/01/waiting-for-postgresql-15-sql-json-query-functions/", "published_at": "2022-04-01T10:13:31+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb635c3ce2e", "title": "Waiting for PostgreSQL 15 – IS JSON predicate", "url": "https://www.depesz.com/2022/04/01/waiting-for-postgresql-15-is-json-predicate/", "published_at": "2022-04-01T01:13:25+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb636bc0633", "title": "Waiting for PostgreSQL 15 – SQL/JSON constructors", "url": "https://www.depesz.com/2022/03/31/waiting-for-postgresql-15-sql-json-constructors/", "published_at": "2022-03-31T19:32:28+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb63740ba85", "title": "Waiting for PostgreSQL 15 – Add support for MERGE SQL command", "url": "https://www.depesz.com/2022/03/31/waiting-for-postgresql-15-add-support-for-merge-sql-command/", "published_at": "2022-03-31T12:44:47+00:00" }, { "id": "01a0c523-328a-7207-869f-bdb637b13906", "title": "Waiting for PostgreSQL 15 – Add support for security invoker views.", "url": "https://www.depesz.com/2022/03/22/waiting-for-postgresql-15-add-support-for-security-invoker-views/", "published_at": "2022-03-22T12:12:58+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113aef01c7d", "title": "PGDayPL postponed…", "url": "https://www.depesz.com/2022/03/16/pgdaypl-postponed/", "published_at": "2022-03-16T13:14:37+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113aef4b1f8", "title": "Is my autovacuum configured properly?", "url": "https://www.depesz.com/2022/03/13/is-my-autovacuum-configured-properly/", "published_at": "2022-03-13T16:14:52+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113afed16c3", "title": "New type of hints on explain.depesz.com", "url": "https://www.depesz.com/2022/03/07/new-type-of-hints-on-explain-depesz-com/", "published_at": "2022-03-07T12:22:50+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b0c52ca1", "title": "How to index data with tsearch?", "url": "https://www.depesz.com/2022/03/01/how-to-index-data-with-tsearch/", "published_at": "2022-03-01T10:54:27+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b16a5207", "title": "PGDayPL is coming :)", "url": "https://www.depesz.com/2022/02/21/pgdaypl-is-coming/", "published_at": "2022-02-21T11:28:06+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b18a2a9e", "title": "explain.depesz.com – now with HINTS!", "url": "https://www.depesz.com/2022/02/16/explain-depesz-com-now-with-hints/", "published_at": "2022-02-16T11:31:43+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b1ba575d", "title": "How much disk space you can save by using INT4/INT instead of INT8/BIGINT?", "url": "https://www.depesz.com/2022/02/13/how-much-disk-space-you-can-save-by-using-int4-int-instead-of-int8-bigint/", "published_at": "2022-02-13T13:37:06+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b29321d9", "title": "Waiting for PostgreSQL 15 – Allow archiving via loadable modules.", "url": "https://www.depesz.com/2022/02/06/waiting-for-postgresql-15-allow-archiving-via-loadable-modules/", "published_at": "2022-02-06T22:55:57+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b34fb22a", "title": "Waiting for PostgreSQL 15 – Add UNIQUE null treatment option", "url": "https://www.depesz.com/2022/02/06/waiting-for-postgresql-15-add-unique-null-treatment-option/", "published_at": "2022-02-06T14:34:48+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b3780313", "title": "Waiting for PostgreSQL 15 – Add HEADER support to COPY text format", "url": "https://www.depesz.com/2022/01/28/waiting-for-postgresql-15-add-header-support-to-copy-text-format/", "published_at": "2022-01-28T11:00:22+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b438c23e", "title": "Waiting for PostgreSQL 15 – Introduce log_destination=jsonlog", "url": "https://www.depesz.com/2022/01/17/waiting-for-postgresql-15-introduce-log_destinationjsonlog/", "published_at": "2022-01-17T11:46:03+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b52717d6", "title": "Configuration changes across Pg versions", "url": "https://www.depesz.com/2022/01/17/configuration-changes-across-pg-versions/", "published_at": "2022-01-17T10:45:14+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b5cf8b41", "title": "Waiting for PostgreSQL 15 – Add assorted new regexp_xxx SQL functions.", "url": "https://www.depesz.com/2021/11/26/waiting-for-postgresql-15-add-assorted-new-regexp_xxx-sql-functions/", "published_at": "2021-11-26T12:04:15+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b6700d35", "title": "Does varchar(n) use less disk space than varchar() or text?", "url": "https://www.depesz.com/2021/11/19/does-varcharn-use-less-disk-space-than-varchar-or-text/", "published_at": "2021-11-19T11:57:36+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b681cd51", "title": "Waiting for PostgreSQL 15 – Allow publishing the tables of schema.", "url": "https://www.depesz.com/2021/11/16/waiting-for-postgresql-15-allow-publishing-the-tables-of-schema/", "published_at": "2021-11-16T09:30:37+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b6f80cb3", "title": "Why is it hard to automatically suggest what index to create?", "url": "https://www.depesz.com/2021/10/22/why-is-it-hard-to-automatically-suggest-what-index-to-create/", "published_at": "2021-10-22T19:43:20+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b761596d", "title": "Using recursive queries to get distinct elements from table", "url": "https://www.depesz.com/2021/09/27/using-recursive-queries-to-get-distinct-elements-from-table/", "published_at": "2021-09-27T07:18:32+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b7cd4dde", "title": "Waiting for PostgreSQL 15 – Revoke PUBLIC CREATE from public schema, now owned by pg_database_owner.", "url": "https://www.depesz.com/2021/09/10/waiting-for-postgresql-15-revoke-public-create-from-public-schema-now-owned-by-pg_database_owner/", "published_at": "2021-09-10T09:28:55+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b83f9393", "title": "How to get advisory lock in shell?", "url": "https://www.depesz.com/2021/08/26/how-to-get-advisory-lock-in-shell/", "published_at": "2021-08-26T15:36:51+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b8716c83", "title": "New changes on explain.depesz.com – fixed calculations of exclusive times", "url": "https://www.depesz.com/2021/08/03/new-changes-on-explain-depesz-com-fixed-calculations-of-exclusive-times/", "published_at": "2021-08-03T19:17:53+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b908cf53", "title": "Display “settings” from plans on explain.depesz.com", "url": "https://www.depesz.com/2021/07/18/display-settings-from-plans-on-explain-depesz-com/", "published_at": "2021-07-18T18:07:33+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113b9e8aeaa", "title": "How to get list of elements from multiranges?", "url": "https://www.depesz.com/2021/07/15/how-to-get-list-of-elements-from-multiranges/", "published_at": "2021-07-15T12:12:46+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113ba450182", "title": "Buffers I/O information on explain.depesz.com", "url": "https://www.depesz.com/2021/07/04/buffers-i-o-information-on-explain-depesz-com/", "published_at": "2021-07-04T19:59:08+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113bb30d533", "title": "A tale of making company-wide standard psqlrc", "url": "https://www.depesz.com/2021/06/23/a-tale-of-making-company-wide-standard-psqlrc/", "published_at": "2021-06-23T16:23:49+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113bb3b0673", "title": "Explaining the unexplainable – part 6: buffers", "url": "https://www.depesz.com/2021/06/20/explaining-the-unexplainable-part-6-buffers/", "published_at": "2021-06-20T13:44:19+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113bc2b935f", "title": "Many changes on explain.depesz.com", "url": "https://www.depesz.com/2021/06/09/many-changes-on-explain-depesz-com/", "published_at": "2021-06-08T22:27:21+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113bc86d595", "title": "Million explain plans…", "url": "https://www.depesz.com/2021/05/18/million-explain-plans/", "published_at": "2021-05-18T06:11:10+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113bd368263", "title": "Getting value from dynamic column in pl/PgSQL triggers?", "url": "https://www.depesz.com/2021/04/21/getting-value-from-dynamic-column-in-pl-pgsql-triggers/", "published_at": "2021-04-21T19:25:54+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113be090f4b", "title": "Changes on explain.depesz.com – extracted query from auto-explain plans", "url": "https://www.depesz.com/2021/04/14/changes-on-explain-depesz-com-extracted-query-from-auto-explain-plans/", "published_at": "2021-04-14T19:01:36+00:00" }, { "id": "01a0c52e-8f91-7297-a78b-b113beb79c7a", "title": "Waiting for PostgreSQL 14 – Add unistr function", "url": "https://www.depesz.com/2021/04/01/waiting-for-postgresql-14-add-unistr-function/", "published_at": "2021-04-01T19:22:47+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e6ef4d696", "title": "Waiting for PostgreSQL 14 – Add “pg_database_owner” default role.", "url": "https://www.depesz.com/2021/04/01/waiting-for-postgresql-14-add-pg_database_owner-default-role/", "published_at": "2021-04-01T04:15:08+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e6ef4ed14", "title": "Waiting for PostgreSQL 14 – Add date_bin function", "url": "https://www.depesz.com/2021/03/31/waiting-for-postgresql-14-add-date_bin-function/", "published_at": "2021-03-31T18:39:35+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e6f5b3637", "title": "Waiting for PostgreSQL 14 – Allow configurable LZ4 TOAST compression.", "url": "https://www.depesz.com/2021/03/22/waiting-for-postgresql-14-allow-configurable-lz4-toast-compression/", "published_at": "2021-03-22T20:18:05+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e6f7dbfd7", "title": "Starting with Pg – where are logs?", "url": "https://www.depesz.com/2021/03/05/starting-with-pg-where-are-logs/", "published_at": "2021-03-05T02:27:08+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e6f8459db", "title": "Fixed display of Backward scans on explain.depesz.com", "url": "https://www.depesz.com/2021/03/03/fixed-display-of-backward-scans-on-explain-depesz-com/", "published_at": "2021-03-03T20:45:11+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e701ed2c7", "title": "Starting with Pg – where/how can I set configuration parameters?", "url": "https://www.depesz.com/2021/03/01/starting-with-pg-where-how-can-i-set-configuration-parameters/", "published_at": "2021-03-01T12:35:18+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e70eb3989", "title": "explain.depesz.com – now with JITs", "url": "https://www.depesz.com/2021/02/19/explain-depesz-com-now-with-jits/", "published_at": "2021-02-19T13:58:19+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e71aa9b5b", "title": "Starting with Pg – where is the config?", "url": "https://www.depesz.com/2021/02/12/starting-with-pg-where-is-the-config/", "published_at": "2021-02-12T13:10:42+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e727b345f", "title": "Why is there database named “postgres”?", "url": "https://www.depesz.com/2021/02/09/why-is-there-database-named-postgres/", "published_at": "2021-02-09T09:42:58+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e72f7e18d", "title": "Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses", "url": "https://www.depesz.com/2021/02/04/waiting-for-postgresql-14-search-and-cycle-clauses/", "published_at": "2021-02-04T10:05:29+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e73895c99", "title": "How to run some tasks without user intervention, at specific times? – part 2", "url": "https://www.depesz.com/2021/01/28/how-to-run-some-tasks-without-user-intervention-at-specific-times-part-2/", "published_at": "2021-01-28T15:38:51+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e73d518ca", "title": "Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time", "url": "https://www.depesz.com/2021/01/18/waiting-for-postgresql-14-add-pg_stat_database-counters-for-sessions-and-session-time/", "published_at": "2021-01-18T12:30:08+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e7449f96b", "title": "Are there limits to partition counts?", "url": "https://www.depesz.com/2021/01/17/are-there-limits-to-partition-counts/", "published_at": "2021-01-17T07:55:10+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e748f5228", "title": "How to run some tasks without user intervention, at specific times?", "url": "https://www.depesz.com/2021/01/15/how-to-run-some-tasks-without-user-intervention-at-specific-times/", "published_at": "2021-01-15T03:17:34+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e750615ba", "title": "Waiting for PostgreSQL 14 – Add idle_session_timeout.", "url": "https://www.depesz.com/2021/01/12/waiting-for-postgresql-14-add-idle_session_timeout/", "published_at": "2021-01-12T22:40:45+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e75415b19", "title": "Waiting for PostgreSQL 14 – Report progress of COPY commands", "url": "https://www.depesz.com/2021/01/12/waiting-for-postgresql-14-report-progress-of-copy-commands/", "published_at": "2021-01-12T10:29:56+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e75775268", "title": "How to limit rows to at most N per category – fix", "url": "https://www.depesz.com/2021/01/08/how-to-limit-rows-to-at-most-n-per-category-fix/", "published_at": "2021-01-08T04:17:23+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e76222dc3", "title": "Fixes on why-upgrade.depesz.com", "url": "https://www.depesz.com/2021/01/07/fixes-on-why-upgrade-depesz-com/", "published_at": "2021-01-07T07:54:09+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e7669acc5", "title": "Reconnecting to SSH servers", "url": "https://www.depesz.com/2021/01/06/reconnecting-to-ssh-servers/", "published_at": "2021-01-06T11:28:29+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e769f4e0a", "title": "How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 2", "url": "https://www.depesz.com/2020/12/29/how-to-install-and-configure-postgresql-debian-ubuntu-for-developer-use-part-2/", "published_at": "2020-12-29T13:30:45+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e76c240c5", "title": "How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 1", "url": "https://www.depesz.com/2020/12/24/how-to-install-and-configure-postgresql-debian-ubuntu-for-developer-use-part-1/", "published_at": "2020-12-24T03:00:53+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e779e3dc3", "title": "Waiting for PostgreSQL 14 – Multirange datatypes", "url": "https://www.depesz.com/2020/12/21/waiting-for-postgresql-14-multirange-datatypes/", "published_at": "2020-12-21T22:10:36+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e781556d4", "title": "Waiting for PostgreSQL 14 – pg_stat_statements: Track time at which all statistics were last reset.", "url": "https://www.depesz.com/2020/12/21/waiting-for-postgresql-14-pg_stat_statements-track-time-at-which-all-statistics-were-last-reset/", "published_at": "2020-12-21T03:15:49+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e78d7a3aa", "title": "Waiting for PostgreSQL 14 – Allow subscripting of hstore values.", "url": "https://www.depesz.com/2020/12/20/waiting-for-postgresql-14-allow-subscripting-of-hstore-values/", "published_at": "2020-12-20T12:07:34+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e78e9d710", "title": "How to limit rows to at most N per category", "url": "https://www.depesz.com/2020/11/24/how-to-limit-rows-to-at-most-n-per-category/", "published_at": "2020-11-24T21:44:06+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e7961b144", "title": "Waiting for PostgreSQL 14 – Provide the OR REPLACE option for CREATE TRIGGER.", "url": "https://www.depesz.com/2020/11/19/3851/", "published_at": "2020-11-19T05:00:05+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e79d78157", "title": "Waiting for PostgreSQL 14 – Support negative indexes in split_part().", "url": "https://www.depesz.com/2020/11/18/waiting-for-postgresql-14-support-negative-indexes-in-split_part/", "published_at": "2020-11-18T20:19:35+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e7a86b9e1", "title": "New functionality on explain.depesz.com", "url": "https://www.depesz.com/2020/11/05/new-functionality-on-explain-depesz-com/", "published_at": "2020-11-05T16:04:16+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e7ae80d3a", "title": "Waiting for PostgreSQL 14 – Support for OUT parameters in procedures", "url": "https://www.depesz.com/2020/10/05/waiting-for-postgresql-14-support-for-out-parameters-in-procedures/", "published_at": "2020-10-05T10:10:38+00:00" }, { "id": "01a0c539-0611-7391-bd08-209e7be6c850", "title": "Waiting for PostgreSQL 13 – psql: Display stats target of extended statistics", "url": "https://www.depesz.com/2020/10/05/waiting-for-postgresql-13-psql-display-stats-target-of-extended-statistics/", "published_at": "2020-10-05T06:39:29+00:00" }, { "id": "01a0c542-6832-73f7-a8f0-14d48700010a", "title": "Waiting for PostgreSQL 13 – Support FETCH FIRST WITH TIES", "url": "https://www.depesz.com/2020/09/22/waiting-for-postgresql-13-support-fetch-first-with-ties/", "published_at": "2020-09-22T19:57:17+00:00" }, { "id": "01a0c542-6832-73f7-a8f0-14d4877d7221", "title": "Waiting for PostgreSQL 14 – Add support for partitioned tables and indexes in REINDEX", "url": "https://www.depesz.com/2020/09/08/waiting-for-postgresql-14-add-support-for-partitioned-tables-and-indexes-in-reindex/", "published_at": "2020-09-08T10:20:32+00:00" }, { "id": "01a0c542-6832-73f7-a8f0-14d487be2f38", "title": "Waiting for PostgreSQL 14 – Improvements for handling large number of connections", "url": "https://www.depesz.com/2020/08/25/waiting-for-postgresql-14-improvements-for-handling-large-number-of-connections/", "published_at": "2020-08-25T02:17:14+00:00" }, { "id": "01a0c542-6832-73f7-a8f0-14d487e0f24f", "title": "Waiting for PostgreSQL 14 – pg_stat_statements: track number of rows processed by some utility commands.", "url": "https://www.depesz.com/2020/08/24/waiting-for-postgresql-14-pg_stat_statements-track-number-of-rows-processed-by-some-utility-commands/", "published_at": "2020-08-24T10:34:43+00:00" }, { "id": "01a0c542-6832-73f7-a8f0-14d488140965", "title": "You can now add query to your plan on explain.depesz.com", "url": "https://www.depesz.com/2020/07/27/you-can-now-add-query-to-your-plan-on-explain-depesz-com/", "published_at": "2020-07-27T13:32:03+00:00" }, { "id": "01a0c542-6832-73f7-a8f0-14d488bc73bf", "title": "Waiting for PostgreSQL 14 – Rename wal_keep_segments to wal_keep_size.", "url": "https://www.depesz.com/2020/07/27/waiting-for-postgresql-14-rename-wal_keep_segments-to-wal_keep_size/", "published_at": "2020-07-27T10:36:33+00:00" }, { "id": "01a0c542-6832-73f7-a8f0-14d4896aeed6", "title": "Changes on explain.depesz.com", "url": "https://www.depesz.com/2020/06/08/changes-on-explain-depesz-com-9/", "published_at": "2020-06-08T11:01:48+00:00" }, { "id": "01a0c542-6832-73f7-a8f0-14d48a2f3661", "title": "Waiting for PostgreSQL 13 – Add logical replication support to replicate into partitioned tables", "url": "https://www.depesz.com/2020/04/17/waiting-for-postgresql-13-add-logical-replication-support-to-replicate-into-partitioned-tables/", "published_at": "2020-04-17T15:49:53+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fb5bd2c0", "title": "Waiting for PostgreSQL 13 – Allow autovacuum to log WAL usage statistics.", "url": "https://www.depesz.com/2020/04/17/waiting-for-postgresql-13-allow-autovacuum-to-log-wal-usage-statistics/", "published_at": "2020-04-17T13:01:49+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fb93372b", "title": "Waiting for PostgreSQL 13 – Add the option to report WAL usage in EXPLAIN and auto_explain.", "url": "https://www.depesz.com/2020/04/17/waiting-for-postgresql-13-add-the-option-to-report-wal-usage-in-explain-and-auto_explain/", "published_at": "2020-04-17T10:52:40+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fb948ea0", "title": "Changes on explain.depesz.com", "url": "https://www.depesz.com/2020/04/03/changes-on-explain-depesz-com-8/", "published_at": "2020-04-03T04:03:30+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fbaa522d", "title": "Waiting for PostgreSQL 13 – Allow pg_stat_statements to track planning statistics.", "url": "https://www.depesz.com/2020/04/02/waiting-for-postgresql-13-allow-pg_stat_statements-to-track-planning-statistics/", "published_at": "2020-04-02T19:26:13+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fbbd2094", "title": "Waiting for PostgreSQL 13 – Enable BEFORE row-level triggers for partitioned tables", "url": "https://www.depesz.com/2020/03/31/waiting-for-postgresql-13-enable-before-row-level-triggers-for-partitioned-tables/", "published_at": "2020-03-31T07:58:30+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fbec0f89", "title": "Initial support for fixing of line-wrapped plans", "url": "https://www.depesz.com/2020/03/16/initial-support-for-fixing-of-line-wrapped-plans/", "published_at": "2020-03-16T16:51:29+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fcb49085", "title": "Why I’m not fan of uuid datatype", "url": "https://www.depesz.com/2020/02/19/why-im-not-fan-of-uuid-datatype/", "published_at": "2020-02-19T07:37:16+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fcdd740f", "title": "Fix for displaying aggregates on explain.depesz.com", "url": "https://www.depesz.com/2020/02/18/fix-for-displaying-aggregates-on-explain-depesz-com/", "published_at": "2020-02-18T16:41:05+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fdaa592a", "title": "Which tables should be auto vacuumed or auto analyzed – UPDATE", "url": "https://www.depesz.com/2020/02/18/which-tables-should-be-auto-vacuumed-or-auto-analyzed-update/", "published_at": "2020-02-18T12:45:57+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fe58e4cd", "title": "Waiting for PostgreSQL 13 – Add %x to default PROMPT1 and PROMPT2 in psql", "url": "https://www.depesz.com/2020/02/17/waiting-for-postgresql-13-add-x-to-default-prompt1-and-prompt2-in-psql/", "published_at": "2020-02-17T20:07:29+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395fee4061c", "title": "Waiting for PostgreSQL 13 – Add leader_pid to pg_stat_activity", "url": "https://www.depesz.com/2020/02/17/waiting-for-postgresql-13-add-leader_pid-to-pg_stat_activity/", "published_at": "2020-02-17T14:24:26+00:00" }, { "id": "01a0c542-6833-70f0-b513-a395ff5b2e7f", "title": "Shout out to heatonist.com", "url": "https://www.depesz.com/2020/02/12/shout-out-to-heatonist-com/", "published_at": "2020-02-12T12:45:54+00:00" } ] posts Claim your blog
Back to Hubert Lubaczewski
Blog · corpus.blog/blogs/depesz.com/posts

Hubert Lubaczewski

depesz.com

2022

Waiting for PostgreSQL 16 – Add test scaffolding for soft error reporting from input functions.original ↗
12 Dec 2022
Picking random element, with weightsoriginal ↗
30 Nov 2022
Run a command every “x seconds”original ↗
22 Nov 2022
Waiting for PostgreSQL 16 – Add support for regexps on database and user entries in pg_hba.conforiginal ↗
3 Nov 2022
Prettify SQL queries from command lineoriginal ↗
21 Sept 2022
What is LATERAL, what is it for, and how can one use it?original ↗
18 Sept 2022
SQL/JSON is postponedoriginal ↗
2 Sept 2022
New SQL pretty printer – based on parsing, and not regexpsoriginal ↗
31 Aug 2022
Better scrolling of long explain plans on explain.depesz.comoriginal ↗
12 Jul 2022
Understanding pg_stat_activityoriginal ↗
5 Jul 2022
How to log selects from specific table?original ↗
4 Jul 2022
Stop the war in Ukraineoriginal ↗
12 Apr 2022
Waiting for PostgreSQL 15 – Documentation for SQL/JSON featuresoriginal ↗
8 Apr 2022
Waiting for PostgreSQL 15 – JSON_TABLEoriginal ↗
6 Apr 2022
DBA tips ‘n tricks – search in every field in a tableoriginal ↗
5 Apr 2022
Waiting for PostgreSQL 15 – SQL/JSON query functionsoriginal ↗
1 Apr 2022
Waiting for PostgreSQL 15 – IS JSON predicateoriginal ↗
1 Apr 2022
Waiting for PostgreSQL 15 – SQL/JSON constructorsoriginal ↗
31 Mar 2022
Waiting for PostgreSQL 15 – Add support for MERGE SQL commandoriginal ↗
31 Mar 2022
Waiting for PostgreSQL 15 – Add support for security invoker views.original ↗
22 Mar 2022
PGDayPL postponed…original ↗
16 Mar 2022
Is my autovacuum configured properly?original ↗
13 Mar 2022
New type of hints on explain.depesz.comoriginal ↗
7 Mar 2022
How to index data with tsearch?original ↗
1 Mar 2022
PGDayPL is coming :)original ↗
21 Feb 2022
explain.depesz.com – now with HINTS!original ↗
16 Feb 2022
How much disk space you can save by using INT4/INT instead of INT8/BIGINT?original ↗
13 Feb 2022
Waiting for PostgreSQL 15 – Allow archiving via loadable modules.original ↗
6 Feb 2022
Waiting for PostgreSQL 15 – Add UNIQUE null treatment optionoriginal ↗
6 Feb 2022
Waiting for PostgreSQL 15 – Add HEADER support to COPY text formatoriginal ↗
28 Jan 2022
Waiting for PostgreSQL 15 – Introduce log_destination=jsonlogoriginal ↗
17 Jan 2022
Configuration changes across Pg versionsoriginal ↗
17 Jan 2022

2021

Waiting for PostgreSQL 15 – Add assorted new regexp_xxx SQL functions.original ↗
26 Nov 2021
Does varchar(n) use less disk space than varchar() or text?original ↗
19 Nov 2021
Waiting for PostgreSQL 15 – Allow publishing the tables of schema.original ↗
16 Nov 2021
Why is it hard to automatically suggest what index to create?original ↗
22 Oct 2021
Using recursive queries to get distinct elements from tableoriginal ↗
27 Sept 2021
Waiting for PostgreSQL 15 – Revoke PUBLIC CREATE from public schema, now owned by pg_database_owner.original ↗
10 Sept 2021
How to get advisory lock in shell?original ↗
26 Aug 2021
New changes on explain.depesz.com – fixed calculations of exclusive timesoriginal ↗
3 Aug 2021
Display “settings” from plans on explain.depesz.comoriginal ↗
18 Jul 2021
How to get list of elements from multiranges?original ↗
15 Jul 2021
Buffers I/O information on explain.depesz.comoriginal ↗
4 Jul 2021
A tale of making company-wide standard psqlrcoriginal ↗
23 Jun 2021
Explaining the unexplainable – part 6: buffersoriginal ↗
20 Jun 2021
Many changes on explain.depesz.comoriginal ↗
8 Jun 2021
Million explain plans…original ↗
18 May 2021
Getting value from dynamic column in pl/PgSQL triggers?original ↗
21 Apr 2021
Changes on explain.depesz.com – extracted query from auto-explain plansoriginal ↗
14 Apr 2021
Waiting for PostgreSQL 14 – Add unistr functionoriginal ↗
1 Apr 2021
Waiting for PostgreSQL 14 – Add “pg_database_owner” default role.original ↗
1 Apr 2021
Waiting for PostgreSQL 14 – Add date_bin functionoriginal ↗
31 Mar 2021
Waiting for PostgreSQL 14 – Allow configurable LZ4 TOAST compression.original ↗
22 Mar 2021
Starting with Pg – where are logs?original ↗
5 Mar 2021
Fixed display of Backward scans on explain.depesz.comoriginal ↗
3 Mar 2021
Starting with Pg – where/how can I set configuration parameters?original ↗
1 Mar 2021
explain.depesz.com – now with JITsoriginal ↗
19 Feb 2021
Starting with Pg – where is the config?original ↗
12 Feb 2021
Why is there database named “postgres”?original ↗
9 Feb 2021
Waiting for PostgreSQL 14 – SEARCH and CYCLE clausesoriginal ↗
4 Feb 2021
How to run some tasks without user intervention, at specific times? – part 2original ↗
28 Jan 2021
Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session timeoriginal ↗
18 Jan 2021
Are there limits to partition counts?original ↗
17 Jan 2021
How to run some tasks without user intervention, at specific times?original ↗
15 Jan 2021
Waiting for PostgreSQL 14 – Add idle_session_timeout.original ↗
12 Jan 2021
Waiting for PostgreSQL 14 – Report progress of COPY commandsoriginal ↗
12 Jan 2021
How to limit rows to at most N per category – fixoriginal ↗
8 Jan 2021
Fixes on why-upgrade.depesz.comoriginal ↗
7 Jan 2021
Reconnecting to SSH serversoriginal ↗
6 Jan 2021

2020

How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 2original ↗
29 Dec 2020
How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 1original ↗
24 Dec 2020
Waiting for PostgreSQL 14 – Multirange datatypesoriginal ↗
21 Dec 2020
Waiting for PostgreSQL 14 – pg_stat_statements: Track time at which all statistics were last reset.original ↗
21 Dec 2020
Waiting for PostgreSQL 14 – Allow subscripting of hstore values.original ↗
20 Dec 2020
How to limit rows to at most N per categoryoriginal ↗
24 Nov 2020
Waiting for PostgreSQL 14 – Provide the OR REPLACE option for CREATE TRIGGER.original ↗
19 Nov 2020
Waiting for PostgreSQL 14 – Support negative indexes in split_part().original ↗
18 Nov 2020
New functionality on explain.depesz.comoriginal ↗
5 Nov 2020
Waiting for PostgreSQL 14 – Support for OUT parameters in proceduresoriginal ↗
5 Oct 2020
Waiting for PostgreSQL 13 – psql: Display stats target of extended statisticsoriginal ↗
5 Oct 2020
Waiting for PostgreSQL 13 – Support FETCH FIRST WITH TIESoriginal ↗
22 Sept 2020
Waiting for PostgreSQL 14 – Add support for partitioned tables and indexes in REINDEXoriginal ↗
8 Sept 2020
Waiting for PostgreSQL 14 – Improvements for handling large number of connectionsoriginal ↗
25 Aug 2020
Waiting for PostgreSQL 14 – pg_stat_statements: track number of rows processed by some utility commands.original ↗
24 Aug 2020
You can now add query to your plan on explain.depesz.comoriginal ↗
27 Jul 2020
Waiting for PostgreSQL 14 – Rename wal_keep_segments to wal_keep_size.original ↗
27 Jul 2020
Changes on explain.depesz.comoriginal ↗
8 Jun 2020
Waiting for PostgreSQL 13 – Add logical replication support to replicate into partitioned tablesoriginal ↗
17 Apr 2020
Waiting for PostgreSQL 13 – Allow autovacuum to log WAL usage statistics.original ↗
17 Apr 2020
Waiting for PostgreSQL 13 – Add the option to report WAL usage in EXPLAIN and auto_explain.original ↗
17 Apr 2020
Changes on explain.depesz.comoriginal ↗
3 Apr 2020
Waiting for PostgreSQL 13 – Allow pg_stat_statements to track planning statistics.original ↗
2 Apr 2020
Waiting for PostgreSQL 13 – Enable BEFORE row-level triggers for partitioned tablesoriginal ↗
31 Mar 2020
Initial support for fixing of line-wrapped plansoriginal ↗
16 Mar 2020
Why I’m not fan of uuid datatypeoriginal ↗
19 Feb 2020
Fix for displaying aggregates on explain.depesz.comoriginal ↗
18 Feb 2020
Which tables should be auto vacuumed or auto analyzed – UPDATEoriginal ↗
18 Feb 2020
Waiting for PostgreSQL 13 – Add %x to default PROMPT1 and PROMPT2 in psqloriginal ↗
17 Feb 2020
Waiting for PostgreSQL 13 – Add leader_pid to pg_stat_activityoriginal ↗
17 Feb 2020
Shout out to heatonist.comoriginal ↗
12 Feb 2020
Previous Next