corpus.blog
41554 blogs · [ { "id": "01a0c542-6833-70f0-b513-a395ffb130c7", "title": "Which tables should be auto vacuumed or auto analyzed?", "url": "https://www.depesz.com/2020/01/29/which-tables-should-be-auto-vacuumed-or-auto-analyzed/", "published_at": "2020-01-29T02:01:28+00:00" }, { "id": "01a0c542-6833-70f0-b513-a396004180b0", "title": "Don’t do these things in PostgreSQL", "url": "https://www.depesz.com/2020/01/28/dont-do-these-things-in-postgresql/", "published_at": "2020-01-28T20:17:46+00:00" }, { "id": "01a0c542-6833-70f0-b513-a396004b8d9d", "title": "Waiting for PostgreSQL 13 – Add functions gcd() and lcm() for integer and numeric types.", "url": "https://www.depesz.com/2020/01/28/waiting-for-postgresql-13-add-functions-gcd-and-lcm-for-integer-and-numeric-types/", "published_at": "2020-01-28T12:46:16+00:00" }, { "id": "01a0c542-6833-70f0-b513-a396008ace4b", "title": "Nothing compares ….", "url": "https://www.depesz.com/2020/01/27/nothing-compares/", "published_at": "2020-01-27T07:18:35+00:00" }, { "id": "01a0c542-6833-70f0-b513-a396011137fb", "title": "Waiting for PostgreSQL 13 – Allow vacuum command to process indexes in parallel.", "url": "https://www.depesz.com/2020/01/21/waiting-for-postgresql-13-allow-vacuum-command-to-process-indexes-in-parallel/", "published_at": "2020-01-21T18:08:26+00:00" }, { "id": "01a0c542-6833-70f0-b513-a396014ce302", "title": "Waiting for PostgreSQL 13 – ALTER TABLE … ALTER COLUMN … DROP EXPRESSION", "url": "https://www.depesz.com/2020/01/14/waiting-for-postgresql-13-alter-table-alter-column-drop-expression/", "published_at": "2020-01-14T14:17:56+00:00" }, { "id": "01a0c542-6833-70f0-b513-a396022e0a76", "title": "Finally – fixed time calculations for parallel plans in explain.depesz.com", "url": "https://www.depesz.com/2020/01/07/finally-fixed-time-calculations-for-parallel-plans-in-explain-depesz-com/", "published_at": "2020-01-07T16:36:01+00:00" }, { "id": "01a0c542-6833-70f0-b513-a39602c36d94", "title": "How to efficiently dump PostgreSQL databases", "url": "https://www.depesz.com/2019/12/10/how-to-effectively-dump-postgresql-databases/", "published_at": "2019-12-10T18:40:21+00:00" }, { "id": "01a0c542-6833-70f0-b513-a39602e20148", "title": "Changes on explain.depesz.com", "url": "https://www.depesz.com/2019/12/03/changes-on-explain-depesz-com-7/", "published_at": "2019-12-03T21:56:46+00:00" }, { "id": "01a0c542-6833-70f0-b513-a39603a8fa44", "title": "Waiting for PostgreSQL 13 – Allow invisible PROMPT2 in psql.", "url": "https://www.depesz.com/2019/11/26/waiting-for-postgresql-13-allow-invisible-prompt2-in-psql/", "published_at": "2019-11-26T18:17:05+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b18fb434", "title": "Waiting for PostgreSQL 13 – Introduce the ‘force’ option for the Drop Database command.", "url": "https://www.depesz.com/2019/11/16/waiting-for-postgresql-13-introduce-the-force-option-for-the-drop-database-command/", "published_at": "2019-11-16T13:02:03+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b1b4fc0a", "title": "Waiting for PostgreSQL 13 – Allow sampling of statements depending on duration", "url": "https://www.depesz.com/2019/11/16/waiting-for-postgresql-13-allow-sampling-of-statements-depending-on-duration/", "published_at": "2019-11-16T12:56:11+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b2a7b999", "title": "More functions for json/yaml/xml plans on explain.depesz.com", "url": "https://www.depesz.com/2019/11/13/more-functions-for-json-yaml-xml-plans-on-explain-depesz-com/", "published_at": "2019-11-13T05:15:32+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b2b07245", "title": "New Pg::Explain and explain.depesz.com", "url": "https://www.depesz.com/2019/11/12/new-pgexplain-and-explain-depesz-com/", "published_at": "2019-11-12T22:41:14+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b3a6684e", "title": "Waiting for PostgreSQL 13 – pgbench: add –partitions and –partition-method options.", "url": "https://www.depesz.com/2019/10/28/waiting-for-postgresql-13-pgbench-add-partitions-and-partition-method-options/", "published_at": "2019-10-28T09:56:28+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b3ff57c5", "title": "How to run short ALTER TABLE without long locking concurrent queries", "url": "https://www.depesz.com/2019/09/26/how-to-run-short-alter-table-without-long-locking-concurrent-queries/", "published_at": "2019-09-26T14:07:29+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b46b9597", "title": "Waiting for PostgreSQL 13 – Support for FF1-FF6 and SSSS datetime format patterns", "url": "https://www.depesz.com/2019/09/17/waiting-for-postgresql-13-support-for-ff1-ff6-and-ssss-datetime-format-patterns/", "published_at": "2019-09-17T18:11:34+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b5589282", "title": "Waiting for PostgreSQL 13 – Add support for –jobs in reindexdb", "url": "https://www.depesz.com/2019/07/31/waiting-for-postgresql-13-add-support-for-jobs-in-reindexdb/", "published_at": "2019-07-30T22:04:31+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b59554f1", "title": "Changes on explain.depesz.com", "url": "https://www.depesz.com/2019/06/18/changes-on-explain-depesz-com-6/", "published_at": "2019-06-18T11:54:00+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b5b61f33", "title": "New shell_util to watch output in multiple tmux panes at once", "url": "https://www.depesz.com/2019/06/18/new-shell_util-to-watch-output-in-multiple-tmux-panes-at-once/", "published_at": "2019-06-18T06:32:35+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b6b4d270", "title": "How to play with upcoming, unreleased, PostgreSQL?", "url": "https://www.depesz.com/2019/05/15/how-to-play-with-upcoming-unreleased-postgresql/", "published_at": "2019-05-14T22:11:45+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b735babd", "title": "Wait for program(s) in tmux panes to end…", "url": "https://www.depesz.com/2019/05/13/wait-for-programs-in-tmux-panes-to-end/", "published_at": "2019-05-13T14:15:23+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b779dc5d", "title": "Waiting for PostgreSQL 12 – Allow VACUUM to be run with index cleanup disabled.", "url": "https://www.depesz.com/2019/05/01/waiting-for-postgresql-12-allow-vacuum-to-be-run-with-index-cleanup-disabled/", "published_at": "2019-05-01T01:02:06+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b7ed39d3", "title": "Waiting for PostgreSQL 12 – Add SETTINGS option to EXPLAIN, to print modified settings.", "url": "https://www.depesz.com/2019/04/30/waiting-for-postgresql-12-add-settings-option-to-explain-to-print-modified-settings/", "published_at": "2019-04-30T18:22:52+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b89e2717", "title": "Waiting for PostgreSQL 12 – Support foreign keys that reference partitioned tables", "url": "https://www.depesz.com/2019/04/24/waiting-for-postgresql-12-support-foreign-keys-that-reference-partitioned-tables/", "published_at": "2019-04-24T09:48:56+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527b9901403", "title": "Waiting for PostgreSQL 12 – Log all statements from a sample of transactions", "url": "https://www.depesz.com/2019/04/18/waiting-for-postgresql-12-log-all-statements-from-a-sample-of-transactions/", "published_at": "2019-04-18T08:01:31+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527ba8b6f0e", "title": "Waiting for PostgreSQL 12 – Report progress of CREATE INDEX operations", "url": "https://www.depesz.com/2019/04/18/waiting-for-postgresql-12-report-progress-of-create-index-operations/", "published_at": "2019-04-18T01:15:52+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527bb0eed3e", "title": "Waiting for PostgreSQL 12 – Generated columns", "url": "https://www.depesz.com/2019/04/17/waiting-for-postgresql-12-generated-columns/", "published_at": "2019-04-17T19:16:03+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527bb845e64", "title": "Waiting for PostgreSQL 12 – REINDEX CONCURRENTLY", "url": "https://www.depesz.com/2019/03/29/waiting-for-postgresql-12-reindex-concurrently/", "published_at": "2019-03-29T15:00:02+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527bbe342aa", "title": "Migrating simple table to partitioned. How?", "url": "https://www.depesz.com/2019/03/19/migrating-simple-table-to-partitioned-how/", "published_at": "2019-03-19T22:57:58+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527bcd53e92", "title": "Waiting for PostgreSQL 12 – Partial implementation of SQL/JSON path language", "url": "https://www.depesz.com/2019/03/19/waiting-for-postgresql-12-partial-implementation-of-sql-json-path-language/", "published_at": "2019-03-19T21:30:44+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527bdbbaa4e", "title": "visual sleep in shell, and shell_utils repo information", "url": "https://www.depesz.com/2019/03/04/visual-sleep-in-shell-and-shell_utils-repo-information/", "published_at": "2019-03-04T20:45:36+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527beb6a397", "title": "Another change on why-upgrade.depesz.com – SEARCH!", "url": "https://www.depesz.com/2019/02/25/another-change-on-why-upgrade-depesz-com-search/", "published_at": "2019-02-25T16:14:41+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527bebb3dba", "title": "why-upgrade updates", "url": "https://www.depesz.com/2019/02/19/why-upgrade-updates/", "published_at": "2019-02-19T20:00:55+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527bee5db1b", "title": "Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior.", "url": "https://www.depesz.com/2019/02/19/waiting-for-postgresql-12-allow-user-control-of-cte-materialization-and-change-the-default-behavior/", "published_at": "2019-02-19T13:25:15+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527bf637181", "title": "Grouping values in shell", "url": "https://www.depesz.com/2019/02/19/grouping-values-in-shell/", "published_at": "2019-02-19T13:06:45+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527c006d215", "title": "Automation for doing stuff in multiple windows in tmux", "url": "https://www.depesz.com/2019/02/04/automation-for-doing-stuff-in-multiple-windows-in-tmux/", "published_at": "2019-02-04T18:46:33+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527c01c5704", "title": "Converting list of integers into list of ranges", "url": "https://www.depesz.com/2019/02/04/converting-list-of-integers-into-list-of-ranges/", "published_at": "2019-02-04T15:13:19+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527c1148433", "title": "Waiting for PostgreSQL 12 – Allow COPY FROM to filter data using WHERE conditions", "url": "https://www.depesz.com/2019/02/03/waiting-for-postgresql-12-allow-copy-from-to-filter-data-using-where-conditions/", "published_at": "2019-02-03T08:47:51+00:00" }, { "id": "01a0c54b-37e1-7170-90b6-c527c11e2752", "title": "Waiting for PostgreSQL 12 – Add log_statement_sample_rate parameter", "url": "https://www.depesz.com/2018/12/05/waiting-for-postgresql-12-add-log_statement_sample_rate-parameter/", "published_at": "2018-12-05T19:34:22+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b143f9df26", "title": "Waiting for PostgreSQL 12 – Add CSV table output mode in psql.", "url": "https://www.depesz.com/2018/11/28/waiting-for-postgresql-12-add-csv-table-output-mode-in-psql/", "published_at": "2018-11-28T02:49:05+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b144463de8", "title": "Waiting for PostgreSQL 12 – Integrate recovery.conf into postgresql.conf", "url": "https://www.depesz.com/2018/11/27/waiting-for-postgresql-12-integrate-recovery-conf-into-postgresql-conf/", "published_at": "2018-11-27T20:29:53+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b1452880f1", "title": "Foreign Key to partitioned table – part 3", "url": "https://www.depesz.com/2018/11/04/foreign-key-to-partitioned-table-part-3/", "published_at": "2018-11-04T18:33:28+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b145b68e9e", "title": "Foreign Key to partitioned table – part 2", "url": "https://www.depesz.com/2018/10/31/foreign-key-to-partitioned-table-part-2/", "published_at": "2018-10-31T01:45:14+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b1465bedf7", "title": "Waiting for PostgreSQL 12 – Add pg_partition_tree to display information about partitions", "url": "https://www.depesz.com/2018/10/30/waiting-for-postgresql-12-add-pg_partition_tree-to-display-information-about-partitions/", "published_at": "2018-10-30T20:33:03+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b146c9a86c", "title": "Waiting for PostgreSQL 12 – Add pg_promote function", "url": "https://www.depesz.com/2018/10/30/waiting-for-postgresql-12-add-pg_promote-function/", "published_at": "2018-10-30T13:08:49+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b146ef1def", "title": "Foreign Key to partitioned table", "url": "https://www.depesz.com/2018/10/02/foreign-key-to-partitioned-table/", "published_at": "2018-10-02T09:02:48+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14705d61b", "title": "pg_terminator released", "url": "https://www.depesz.com/2018/09/25/pg_terminator-released/", "published_at": "2018-09-25T10:04:07+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b1473a0976", "title": "Waiting for PostgreSQL 12 – Allow multi-inserts during COPY into a partitioned table", "url": "https://www.depesz.com/2018/08/13/waiting-for-postgresql-12-allow-multi-inserts-during-copy-into-a-partitioned-table/", "published_at": "2018-08-13T18:36:32+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b147cf3e87", "title": "I’m starting my wait for PostgreSQL 12", "url": "https://www.depesz.com/2018/07/02/im-starting-my-wait-for-postgresql-12/", "published_at": "2018-07-02T08:48:56+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14815aa28", "title": "Waiting for PostgreSQL 11 – Improve run-time partition pruning to handle any stable expression.", "url": "https://www.depesz.com/2018/06/25/waiting-for-postgresql-11-improve-run-time-partition-pruning-to-handle-any-stable-expression/", "published_at": "2018-06-25T18:16:59+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b148ba8fc8", "title": "Projects migrated", "url": "https://www.depesz.com/2018/06/07/projects-migrated/", "published_at": "2018-06-07T09:51:55+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b148c247bb", "title": "Waiting for PostgreSQL 11 – Support partition pruning at execution time", "url": "https://www.depesz.com/2018/05/01/waiting-for-postgresql-11-support-partition-pruning-at-execution-time/", "published_at": "2018-05-01T16:41:52+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b149a1a9c0", "title": "Waiting for PostgreSQL 11 – Indexes with INCLUDE columns and their support in B-tree", "url": "https://www.depesz.com/2018/04/26/waiting-for-postgresql-11-indexes-with-include-columns-and-their-support-in-b-tree/", "published_at": "2018-04-26T13:45:05+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14a69afe5", "title": "Waiting for PostgreSQL 11 – Add json(b)_to_tsvector function", "url": "https://www.depesz.com/2018/04/23/waiting-for-postgresql-11-add-jsonb_to_tsvector-function/", "published_at": "2018-04-23T18:18:06+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14b621875", "title": "Waiting for PostgreSQL 11 – Transforms for jsonb to PL/Python and to PL/Perl", "url": "https://www.depesz.com/2018/04/17/waiting-for-postgresql-11-transforms-for-jsonb-to-pl-python-and-to-pl-perl/", "published_at": "2018-04-17T18:21:30+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14bd631e9", "title": "paste.depesz.com is back (for good?)", "url": "https://www.depesz.com/2018/04/13/paste-depesz-com-is-back-for-good/", "published_at": "2018-04-13T13:21:22+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14c75ea55", "title": "Waiting for PostgreSQL 11 – MERGE SQL Command following SQL:2016", "url": "https://www.depesz.com/2018/04/10/waiting-for-postgresql-11-merge-sql-command-following-sql2016/", "published_at": "2018-04-10T18:53:01+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14ccd1077", "title": "Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default", "url": "https://www.depesz.com/2018/04/04/waiting-for-postgresql-11-fast-alter-table-add-column-with-a-non-null-default/", "published_at": "2018-04-04T16:58:33+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14ce6ded8", "title": "paste.depesz.com is no more", "url": "https://www.depesz.com/2018/03/12/paste-depesz-com-is-no-more/", "published_at": "2018-03-12T10:03:52+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14cf0449c", "title": "What is the benefit of upgrading PostgreSQL?", "url": "https://www.depesz.com/2018/02/22/what-is-the-benefit-of-upgrading-postgresql/", "published_at": "2018-02-22T18:36:47+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14d159a02", "title": "Which schema is using the most disk space?", "url": "https://www.depesz.com/2018/02/17/which-schema-is-using-the-most-disk-space/", "published_at": "2018-02-17T13:05:24+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14d49737c", "title": "Waiting for PostgreSQL 11 – Support all SQL:2011 options for window frame clauses.", "url": "https://www.depesz.com/2018/02/13/waiting-for-postgresql-11-support-all-sql2011-options-for-window-frame-clauses/", "published_at": "2018-02-13T13:29:35+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14da1a8e6", "title": "Waiting for PostgreSQL 11 – Support parallel btree index builds.", "url": "https://www.depesz.com/2018/02/12/waiting-for-postgresql-11-support-parallel-btree-index-builds/", "published_at": "2018-02-12T15:12:14+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14dabbe52", "title": "Fix for parallel scans on explain.depesz.com", "url": "https://www.depesz.com/2018/02/05/fix-for-parallel-scans-on-explain-depesz-com/", "published_at": "2018-02-05T12:30:23+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14debee58", "title": "Waiting for PostgreSQL 11 – Allow UPDATE to move rows between partitions.", "url": "https://www.depesz.com/2018/01/22/waiting-for-postgresql-11-allow-update-to-move-rows-between-partitions/", "published_at": "2018-01-22T18:01:33+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14ed5e26f", "title": "Changes on explain.depesz.com", "url": "https://www.depesz.com/2017/11/29/changes-on-explain-depesz-com-5/", "published_at": "2017-11-29T16:49:49+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14f34a552", "title": "Waiting for PostgreSQL 11 – Add hash partitioning.", "url": "https://www.depesz.com/2017/11/10/waiting-for-postgresql-11-add-hash-partitioning/", "published_at": "2017-11-10T13:22:26+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14fb3f331", "title": "Waiting for PostgreSQL 11 – Add psql variables to track success/failure of SQL queries.", "url": "https://www.depesz.com/2017/09/21/waiting-for-postgresql-11-add-psql-variables-to-track-successfailure-of-sql-queries/", "published_at": "2017-09-21T14:08:56+00:00" }, { "id": "01a0c553-7a98-719f-8b31-d2b14fcd331a", "title": "Waiting for PostgreSQL 11 – Add \\gdesc psql command.", "url": "https://www.depesz.com/2017/09/21/waiting-for-postgresql-11-add-gdesc-psql-command/", "published_at": "2017-09-21T13:20:53+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e5aea9934", "title": "New functions in versioning", "url": "https://www.depesz.com/2017/08/07/new-functions-in-versioning/", "published_at": "2017-08-07T14:43:17+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e5b6b4fe4", "title": "How to make sure there is always at least one “sub” record?", "url": "https://www.depesz.com/2017/07/03/how-to-make-sure-there-is-always-at-least-one-sub-record/", "published_at": "2017-07-03T12:39:47+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e5b8ef217", "title": "explain.depesz.com, paste.depesz.com – TOR announcement and some updates", "url": "https://www.depesz.com/2017/06/22/explain-depesz-com-paste-depesz-com-tor-announcement-and-some-updates/", "published_at": "2017-06-22T16:23:14+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e5c69f45c", "title": "Waiting for PostgreSQL 10 – Implement syntax for transition tables in AFTER triggers.", "url": "https://www.depesz.com/2017/06/02/waiting-for-postgresql-10-implement-syntax-for-transition-tables-in-after-triggers/", "published_at": "2017-06-02T10:39:58+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e5cd4457b", "title": "New change on explain.depesz.com", "url": "https://www.depesz.com/2017/05/19/new-change-on-explain-depesz-com/", "published_at": "2017-05-19T18:26:46+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e5dbd3c93", "title": "Waiting for PostgreSQL 10 – Implement multivariate n-distinct coefficients", "url": "https://www.depesz.com/2017/05/19/waiting-for-postgresql-10-implement-multivariate-n-distinct-coefficients/", "published_at": "2017-05-19T12:14:06+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e5e256460", "title": "Waiting for PostgreSQL 10 – Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).", "url": "https://www.depesz.com/2017/04/18/waiting-for-postgresql-10-support-scram-sha-256-authentication-rfc-5802-and-7677/", "published_at": "2017-04-18T14:00:17+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e5efca142", "title": "Waiting for PostgreSQL 10 – Identity columns", "url": "https://www.depesz.com/2017/04/10/waiting-for-postgresql-10-identity-columns/", "published_at": "2017-04-10T21:58:01+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e5fb7d4b1", "title": "Waiting for PostgreSQL 10 – Full Text Search support for json and jsonb", "url": "https://www.depesz.com/2017/04/04/waiting-for-postgresql-10-full-text-search-support-for-json-and-jsonb/", "published_at": "2017-04-04T04:17:46+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e601a31f6", "title": "Waiting for PostgreSQL 10 – Support \\if … \\elif … \\else … \\endif in psql scripting.", "url": "https://www.depesz.com/2017/04/03/waiting-for-postgresql-10-support-if-elif-else-endif-in-psql-scripting/", "published_at": "2017-04-03T20:34:18+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e60a339f5", "title": "Waiting for PostgreSQL 10 – Logical replication support for initial data copy", "url": "https://www.depesz.com/2017/04/03/waiting-for-postgresql-10-logical-replication-support-for-initial-data-copy/", "published_at": "2017-04-03T10:19:49+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e612867a6", "title": "Waiting for PostgreSQL 10 – hash indexing vs. WAL", "url": "https://www.depesz.com/2017/03/15/waiting-for-postgresql-10-hash-indexing-vs-wal/", "published_at": "2017-03-15T12:03:48+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e61c7b8a8", "title": "Waiting for PostgreSQL 10 – Support XMLTABLE query expression", "url": "https://www.depesz.com/2017/03/09/waiting-for-postgresql-10-support-xmltable-query-expression/", "published_at": "2017-03-09T17:21:19+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e6244a717", "title": "Waiting for PostgreSQL 10 – psql: Add \\gx command", "url": "https://www.depesz.com/2017/03/07/waiting-for-postgresql-10-psql-add-gx-command/", "published_at": "2017-03-07T14:45:52+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e62bdcc06", "title": "A way to share SQL queries – paste.depesz.com", "url": "https://www.depesz.com/2017/02/27/a-way-to-share-sql-queries-paste-depesz-com/", "published_at": "2017-02-27T16:03:02+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e63b9f13c", "title": "Getting first and last values per group", "url": "https://www.depesz.com/2017/02/20/getting-first-and-last-values-per-group/", "published_at": "2017-02-20T16:14:54+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e63ce4b0e", "title": "Why does “sudo ls -l /proc/1/fd/*” fail?", "url": "https://www.depesz.com/2017/02/20/why-does-sudo-ls-l-proc1fd-fail/", "published_at": "2017-02-20T13:00:24+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e641a840f", "title": "Waiting for PostgreSQL 10 – Logical replication", "url": "https://www.depesz.com/2017/02/07/waiting-for-postgresql-10-logical-replication/", "published_at": "2017-02-07T11:00:39+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e64d948f4", "title": "Waiting for PostgreSQL 10 – Add pg_sequence system catalog", "url": "https://www.depesz.com/2017/02/06/waiting-for-postgresql-10-add-pg_sequence-system-catalog/", "published_at": "2017-02-06T21:40:32+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e652b9a55", "title": "Generate short, random, textual IDs", "url": "https://www.depesz.com/2017/02/06/generate-short-random-textual-ids/", "published_at": "2017-02-06T15:39:34+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e65ff1247", "title": "Waiting for PostgreSQL 10 – Implement table partitioning.", "url": "https://www.depesz.com/2017/02/06/waiting-for-postgresql-10-implement-table-partitioning/", "published_at": "2017-02-06T09:20:38+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e6677efb7", "title": "Major-version upgrading with minimal downtime", "url": "https://www.depesz.com/2016/11/08/major-version-upgrading-with-minimal-downtime/", "published_at": "2016-11-08T19:45:08+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e66bdc646", "title": "Waiting for PostgreSQL 10 – postgres_fdw: Push down aggregates to remote servers.", "url": "https://www.depesz.com/2016/10/25/waiting-for-postgresql-10-postgres_fdw-push-down-aggregates-to-remote-servers/", "published_at": "2016-10-25T09:15:45+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e67873775", "title": "Waiting for PostgreSQL 10 – Rename “pg_xlog” directory to “pg_wal”.", "url": "https://www.depesz.com/2016/10/25/waiting-for-postgresql-10-rename-pg_xlog-directory-to-pg_wal/", "published_at": "2016-10-25T08:37:53+00:00" }, { "id": "01a0c55b-e2ea-72fd-9caa-b26e68440421", "title": "Missing waiting for …. ?", "url": "https://www.depesz.com/2016/09/26/missing-waiting-for/", "published_at": "2016-09-26T16:41:01+00:00" }, { "id": "01a0c55b-e2eb-70de-9d43-2581430f9945", "title": "Getting list of unique elements in table, per group", "url": "https://www.depesz.com/2016/07/12/getting-list-of-unique-elements-in-table-per-group/", "published_at": "2016-07-12T15:12:52+00:00" }, { "id": "01a0c55b-e2eb-70de-9d43-2581440e1122", "title": "What’s happening in my database?", "url": "https://www.depesz.com/2016/06/29/whats-happening-in-my-database/", "published_at": "2016-06-29T13:14:15+00:00" }, { "id": "01a0c55b-e2eb-70de-9d43-258144d315e5", "title": "Incrementing counters in database", "url": "https://www.depesz.com/2016/06/14/incrementing-counters-in-database/", "published_at": "2016-06-14T14:00:20+00:00" }, { "id": "01a0c55b-e2eb-70de-9d43-25814575215b", "title": "The hard math of killing zombies in Zombicide", "url": "https://www.depesz.com/2016/05/17/the-hard-math-of-killing-zombies-in-zombicide/", "published_at": "2016-05-17T14:14:26+00:00" }, { "id": "01a0c55b-e2eb-70de-9d43-258145852a9b", "title": "Picking task from queue – revisit", "url": "https://www.depesz.com/2016/05/04/picking-task-from-queue-revisit/", "published_at": "2016-05-04T18:42:36+00:00" } ] posts Claim your blog
Back to Hubert Lubaczewski
Blog · corpus.blog/blogs/depesz.com/posts

Hubert Lubaczewski

depesz.com

2020

Which tables should be auto vacuumed or auto analyzed?original ↗
29 Jan 2020
Don’t do these things in PostgreSQLoriginal ↗
28 Jan 2020
Waiting for PostgreSQL 13 – Add functions gcd() and lcm() for integer and numeric types.original ↗
28 Jan 2020
Nothing compares ….original ↗
27 Jan 2020
Waiting for PostgreSQL 13 – Allow vacuum command to process indexes in parallel.original ↗
21 Jan 2020
Waiting for PostgreSQL 13 – ALTER TABLE … ALTER COLUMN … DROP EXPRESSIONoriginal ↗
14 Jan 2020
Finally – fixed time calculations for parallel plans in explain.depesz.comoriginal ↗
7 Jan 2020

2019

How to efficiently dump PostgreSQL databasesoriginal ↗
10 Dec 2019
Changes on explain.depesz.comoriginal ↗
3 Dec 2019
Waiting for PostgreSQL 13 – Allow invisible PROMPT2 in psql.original ↗
26 Nov 2019
Waiting for PostgreSQL 13 – Introduce the ‘force’ option for the Drop Database command.original ↗
16 Nov 2019
Waiting for PostgreSQL 13 – Allow sampling of statements depending on durationoriginal ↗
16 Nov 2019
More functions for json/yaml/xml plans on explain.depesz.comoriginal ↗
13 Nov 2019
New Pg::Explain and explain.depesz.comoriginal ↗
12 Nov 2019
Waiting for PostgreSQL 13 – pgbench: add –partitions and –partition-method options.original ↗
28 Oct 2019
How to run short ALTER TABLE without long locking concurrent queriesoriginal ↗
26 Sept 2019
Waiting for PostgreSQL 13 – Support for FF1-FF6 and SSSS datetime format patternsoriginal ↗
17 Sept 2019
Waiting for PostgreSQL 13 – Add support for –jobs in reindexdboriginal ↗
30 Jul 2019
Changes on explain.depesz.comoriginal ↗
18 Jun 2019
New shell_util to watch output in multiple tmux panes at onceoriginal ↗
18 Jun 2019
How to play with upcoming, unreleased, PostgreSQL?original ↗
14 May 2019
Wait for program(s) in tmux panes to end…original ↗
13 May 2019
Waiting for PostgreSQL 12 – Allow VACUUM to be run with index cleanup disabled.original ↗
1 May 2019
Waiting for PostgreSQL 12 – Add SETTINGS option to EXPLAIN, to print modified settings.original ↗
30 Apr 2019
Waiting for PostgreSQL 12 – Support foreign keys that reference partitioned tablesoriginal ↗
24 Apr 2019
Waiting for PostgreSQL 12 – Log all statements from a sample of transactionsoriginal ↗
18 Apr 2019
Waiting for PostgreSQL 12 – Report progress of CREATE INDEX operationsoriginal ↗
18 Apr 2019
Waiting for PostgreSQL 12 – Generated columnsoriginal ↗
17 Apr 2019
Waiting for PostgreSQL 12 – REINDEX CONCURRENTLYoriginal ↗
29 Mar 2019
Migrating simple table to partitioned. How?original ↗
19 Mar 2019
Waiting for PostgreSQL 12 – Partial implementation of SQL/JSON path languageoriginal ↗
19 Mar 2019
visual sleep in shell, and shell_utils repo informationoriginal ↗
4 Mar 2019
Another change on why-upgrade.depesz.com – SEARCH!original ↗
25 Feb 2019
why-upgrade updatesoriginal ↗
19 Feb 2019
Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior.original ↗
19 Feb 2019
Grouping values in shelloriginal ↗
19 Feb 2019
Automation for doing stuff in multiple windows in tmuxoriginal ↗
4 Feb 2019
Converting list of integers into list of rangesoriginal ↗
4 Feb 2019
Waiting for PostgreSQL 12 – Allow COPY FROM to filter data using WHERE conditionsoriginal ↗
3 Feb 2019

2018

Waiting for PostgreSQL 12 – Add log_statement_sample_rate parameteroriginal ↗
5 Dec 2018
Waiting for PostgreSQL 12 – Add CSV table output mode in psql.original ↗
28 Nov 2018
Waiting for PostgreSQL 12 – Integrate recovery.conf into postgresql.conforiginal ↗
27 Nov 2018
Foreign Key to partitioned table – part 3original ↗
4 Nov 2018
Foreign Key to partitioned table – part 2original ↗
31 Oct 2018
Waiting for PostgreSQL 12 – Add pg_partition_tree to display information about partitionsoriginal ↗
30 Oct 2018
Waiting for PostgreSQL 12 – Add pg_promote functionoriginal ↗
30 Oct 2018
Foreign Key to partitioned tableoriginal ↗
2 Oct 2018
pg_terminator releasedoriginal ↗
25 Sept 2018
Waiting for PostgreSQL 12 – Allow multi-inserts during COPY into a partitioned tableoriginal ↗
13 Aug 2018
I’m starting my wait for PostgreSQL 12original ↗
2 Jul 2018
Waiting for PostgreSQL 11 – Improve run-time partition pruning to handle any stable expression.original ↗
25 Jun 2018
Projects migratedoriginal ↗
7 Jun 2018
Waiting for PostgreSQL 11 – Support partition pruning at execution timeoriginal ↗
1 May 2018
Waiting for PostgreSQL 11 – Indexes with INCLUDE columns and their support in B-treeoriginal ↗
26 Apr 2018
Waiting for PostgreSQL 11 – Add json(b)_to_tsvector functionoriginal ↗
23 Apr 2018
Waiting for PostgreSQL 11 – Transforms for jsonb to PL/Python and to PL/Perloriginal ↗
17 Apr 2018
paste.depesz.com is back (for good?)original ↗
13 Apr 2018
Waiting for PostgreSQL 11 – MERGE SQL Command following SQL:2016original ↗
10 Apr 2018
Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL defaultoriginal ↗
4 Apr 2018
paste.depesz.com is no moreoriginal ↗
12 Mar 2018
What is the benefit of upgrading PostgreSQL?original ↗
22 Feb 2018
Which schema is using the most disk space?original ↗
17 Feb 2018
Waiting for PostgreSQL 11 – Support all SQL:2011 options for window frame clauses.original ↗
13 Feb 2018
Waiting for PostgreSQL 11 – Support parallel btree index builds.original ↗
12 Feb 2018
Fix for parallel scans on explain.depesz.comoriginal ↗
5 Feb 2018
Waiting for PostgreSQL 11 – Allow UPDATE to move rows between partitions.original ↗
22 Jan 2018

2017

Changes on explain.depesz.comoriginal ↗
29 Nov 2017
Waiting for PostgreSQL 11 – Add hash partitioning.original ↗
10 Nov 2017
Waiting for PostgreSQL 11 – Add psql variables to track success/failure of SQL queries.original ↗
21 Sept 2017
Waiting for PostgreSQL 11 – Add \gdesc psql command.original ↗
21 Sept 2017
New functions in versioningoriginal ↗
7 Aug 2017
How to make sure there is always at least one “sub” record?original ↗
3 Jul 2017
explain.depesz.com, paste.depesz.com – TOR announcement and some updatesoriginal ↗
22 Jun 2017
Waiting for PostgreSQL 10 – Implement syntax for transition tables in AFTER triggers.original ↗
2 Jun 2017
New change on explain.depesz.comoriginal ↗
19 May 2017
Waiting for PostgreSQL 10 – Implement multivariate n-distinct coefficientsoriginal ↗
19 May 2017
Waiting for PostgreSQL 10 – Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).original ↗
18 Apr 2017
Waiting for PostgreSQL 10 – Identity columnsoriginal ↗
10 Apr 2017
Waiting for PostgreSQL 10 – Full Text Search support for json and jsonboriginal ↗
4 Apr 2017
Waiting for PostgreSQL 10 – Support \if … \elif … \else … \endif in psql scripting.original ↗
3 Apr 2017
Waiting for PostgreSQL 10 – Logical replication support for initial data copyoriginal ↗
3 Apr 2017
Waiting for PostgreSQL 10 – hash indexing vs. WALoriginal ↗
15 Mar 2017
Waiting for PostgreSQL 10 – Support XMLTABLE query expressionoriginal ↗
9 Mar 2017
Waiting for PostgreSQL 10 – psql: Add \gx commandoriginal ↗
7 Mar 2017
A way to share SQL queries – paste.depesz.comoriginal ↗
27 Feb 2017
Getting first and last values per grouporiginal ↗
20 Feb 2017
Why does “sudo ls -l /proc/1/fd/*” fail?original ↗
20 Feb 2017
Waiting for PostgreSQL 10 – Logical replicationoriginal ↗
7 Feb 2017
Waiting for PostgreSQL 10 – Add pg_sequence system catalogoriginal ↗
6 Feb 2017
Generate short, random, textual IDsoriginal ↗
6 Feb 2017
Waiting for PostgreSQL 10 – Implement table partitioning.original ↗
6 Feb 2017

2016

Major-version upgrading with minimal downtimeoriginal ↗
8 Nov 2016
Waiting for PostgreSQL 10 – postgres_fdw: Push down aggregates to remote servers.original ↗
25 Oct 2016
Waiting for PostgreSQL 10 – Rename “pg_xlog” directory to “pg_wal”.original ↗
25 Oct 2016
Missing waiting for …. ?original ↗
26 Sept 2016
Getting list of unique elements in table, per grouporiginal ↗
12 Jul 2016
What’s happening in my database?original ↗
29 Jun 2016
Incrementing counters in databaseoriginal ↗
14 Jun 2016
The hard math of killing zombies in Zombicideoriginal ↗
17 May 2016
Picking task from queue – revisitoriginal ↗
4 May 2016
Previous Next