corpus.blog
41554 blogs · [ { "id": "01a0c564-2c96-7065-ba2a-f56fa584482b", "title": "Waiting for 9.6 – Support \\crosstabview in psql", "url": "https://www.depesz.com/2016/04/27/waiting-for-9-6-support-crosstabview-in-psql/", "published_at": "2016-04-27T14:39:08+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa5d253bb", "title": "Waiting for 9.6 – Phrase full text search.", "url": "https://www.depesz.com/2016/04/22/waiting-for-9-6-phrase-full-text-search/", "published_at": "2016-04-22T20:52:55+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa5dcd9db", "title": "Waiting for 9.6 – Add a \\gexec command to psql for evaluation of computed queries.", "url": "https://www.depesz.com/2016/04/22/waiting-for-9-6-add-a-gexec-command-to-psql-for-evaluation-of-computed-queries/", "published_at": "2016-04-22T13:14:21+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa64a68d4", "title": "Waiting for 9.6 – Bloom index contrib module", "url": "https://www.depesz.com/2016/04/11/waiting-for-9-6-bloom-index-contrib-module/", "published_at": "2016-04-11T10:38:30+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa6c2d516", "title": "Change on explain.depesz.com", "url": "https://www.depesz.com/2016/04/05/change-on-explain-depesz-com/", "published_at": "2016-04-05T13:11:12+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa6c99e49", "title": "Waiting for 9.6 – Support parallel aggregation.", "url": "https://www.depesz.com/2016/03/23/waiting-for-9-6-support-parallel-aggregation/", "published_at": "2016-03-23T18:53:45+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa7bdd1a7", "title": "Waiting for 9.6 – Directly modify foreign tables.", "url": "https://www.depesz.com/2016/03/22/waiting-for-9-6-directly-modify-foreign-tables/", "published_at": "2016-03-22T17:53:57+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa8273013", "title": "Waiting for 9.6 – Add idle_in_transaction_session_timeout.", "url": "https://www.depesz.com/2016/03/22/waiting-for-9-6-add-idle_in_transaction_session_timeout/", "published_at": "2016-03-22T09:19:57+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa887e03b", "title": "Waiting for 9.6 – Add simple VACUUM progress reporting.", "url": "https://www.depesz.com/2016/03/22/waiting-for-9-6-add-simple-vacuum-progress-reporting/", "published_at": "2016-03-22T00:57:17+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa916e23d", "title": "Waiting for 9.6 – Tsvector editing functions", "url": "https://www.depesz.com/2016/03/21/waiting-for-9-6-tsvector-editing-functions/", "published_at": "2016-03-21T18:33:39+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa93c52ac", "title": "Waiting for 9.6 – Add a generic command progress reporting facility.", "url": "https://www.depesz.com/2016/03/09/waiting-for-9-6-add-a-generic-command-progress-reporting-facility/", "published_at": "2016-03-09T18:44:04+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fa9a60324", "title": "Waiting for 9.6 – Add new system view, pg_config", "url": "https://www.depesz.com/2016/02/29/waiting-for-9-6-add-new-system-view-pg_config/", "published_at": "2016-02-29T14:55:46+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56faa0c0c34", "title": "Waiting for 9.6 – Remove GROUP BY columns that are functionally dependent on other columns.", "url": "https://www.depesz.com/2016/02/16/waiting-for-9-6-remove-group-by-columns-that-are-functionally-dependent-on-other-columns/", "published_at": "2016-02-16T08:28:45+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56faafe5092", "title": "explain.depesz.com – new change and some stats", "url": "https://www.depesz.com/2016/02/08/explain-depesz-com-new-change-and-some-stats/", "published_at": "2016-02-08T19:30:56+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fab636e94", "title": "Waiting for 9.6 – Add num_nulls() and num_nonnulls() to count NULL arguments.", "url": "https://www.depesz.com/2016/02/08/waiting-for-9-6-add-num_nulls-and-num_nonnulls-to-count-null-arguments/", "published_at": "2016-02-08T15:42:05+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fabce752a", "title": "Waiting for 9.6 – Add trigonometric functions that work in degrees.", "url": "https://www.depesz.com/2016/02/01/waiting-for-9-6-add-trigonometric-functions-that-work-in-degrees/", "published_at": "2016-02-01T20:14:16+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fac582d46", "title": "Waiting for 9.6 – Support parallel joins, and make related improvements.", "url": "https://www.depesz.com/2016/02/01/waiting-for-9-6-support-parallel-joins-and-make-related-improvements/", "published_at": "2016-02-01T19:48:18+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56facd93b20", "title": "Waiting for 9.6 – Allow to omit boundaries in array subscript", "url": "https://www.depesz.com/2016/01/10/waiting-for-9-6-allow-to-omit-boundaries-in-array-subscript/", "published_at": "2016-01-10T11:32:07+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fad55cc27", "title": "Waiting for 9.6 – Cube extension kNN support", "url": "https://www.depesz.com/2016/01/10/waiting-for-9-6-cube-extension-knn-support/", "published_at": "2016-01-10T11:17:07+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fae33921f", "title": "Waiting for 9.6 – Allow EXPLAIN (ANALYZE, VERBOSE) to display per-worker statistics.", "url": "https://www.depesz.com/2015/12/15/waiting-for-9-6-allow-explain-analyze-verbose-to-display-per-worker-statistics/", "published_at": "2015-12-15T02:46:32+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fae9320b0", "title": "Waiting for 9.6 – psql: Support multiple -c and -f options, and allow mixing them.", "url": "https://www.depesz.com/2015/12/14/waiting-for-9-6-psql-support-multiple-c-and-f-options-and-allow-mixing-them/", "published_at": "2015-12-14T19:13:46+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56faf53e459", "title": "Grouping data by timestamp and interval", "url": "https://www.depesz.com/2015/12/08/grouping-data-by-timestamp-and-interval/", "published_at": "2015-12-08T17:01:47+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56faf7f62ca", "title": "Waiting for 9.6 – Generate parallel sequential scan plans in simple cases.", "url": "https://www.depesz.com/2015/11/17/waiting-for-9-6-generate-parallel-sequential-scan-plans-in-simple-cases/", "published_at": "2015-11-17T20:55:42+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56faf9db9ec", "title": "Waiting for 9.6 – Implement lookbehind constraints in our regular-expression engine.", "url": "https://www.depesz.com/2015/11/17/waiting-for-9-6-implement-lookbehind-constraints-in-our-regular-expression-engine/", "published_at": "2015-11-17T19:37:35+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fb09c4959", "title": "Is C faster for (instagram-style) ID generation?", "url": "https://www.depesz.com/2015/10/30/is-c-faster-for-instagram-style-id-generation/", "published_at": "2015-10-30T16:04:51+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fb1308bfc", "title": "explain.depesz.com changes and new stats", "url": "https://www.depesz.com/2015/10/13/explain-depesz-com-changes-and-new-stats/", "published_at": "2015-10-13T11:07:24+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fb224b338", "title": "Waiting for 9.6 – Add CASCADE support for CREATE EXTENSION.", "url": "https://www.depesz.com/2015/10/08/waiting-for-9-6-add-cascade-support-for-create-extension/", "published_at": "2015-10-08T19:49:38+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fb30567b8", "title": "Converting Logical Volume so that it’s striped", "url": "https://www.depesz.com/2015/10/08/converting-logical-volume-so-that-its-striped/", "published_at": "2015-10-08T19:37:15+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fb32b7bb4", "title": "Waiting for 9.6 – Allow per-tablespace effective_io_concurrency", "url": "https://www.depesz.com/2015/09/22/waiting-for-9-6-allow-per-tablespace-effective_io_concurrency/", "published_at": "2015-09-22T17:49:14+00:00" }, { "id": "01a0c564-2c96-7065-ba2a-f56fb383d75d", "title": "Waiting for 9.6 – Add log_line_prefix option ‘n’ for Unix epoch.", "url": "https://www.depesz.com/2015/09/22/waiting-for-9-6-add-log_line_prefix-option-n-for-unix-epoch/", "published_at": "2015-09-22T17:33:36+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f79399deefc4", "title": "Waiting for 9.6 – Allow usage of huge maintenance_work_mem for GIN build.", "url": "https://www.depesz.com/2015/09/15/waiting-for-9-6-allow-usage-of-huge-maintenance_work_mem-for-gin-build/", "published_at": "2015-09-15T08:21:13+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939aa64947", "title": "Hypothetical indexes", "url": "https://www.depesz.com/2015/09/07/hypothetical-indexes/", "published_at": "2015-09-07T17:31:07+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939b17c0ed", "title": "Waiting for 9.6 – Add IF NOT EXISTS processing to ALTER TABLE ADD COLUMN", "url": "https://www.depesz.com/2015/08/19/waiting-for-9-6-add-if-not-exists-processing-to-alter-table-add-column/", "published_at": "2015-08-19T01:17:30+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939c146d26", "title": "Waiting for 9.6 – Add new function pg_notification_queue_usage.", "url": "https://www.depesz.com/2015/08/18/waiting-for-9-6-add-new-function-pg_notification_queue_usage/", "published_at": "2015-08-18T02:12:42+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939c5ed28a", "title": "Waiting for 9.6 – Add psql PROMPT variable showing the pid of the connected to backend.", "url": "https://www.depesz.com/2015/08/17/waiting-for-9-6-add-psql-prompt-variable-showing-the-pid-of-the-connected-to-backend/", "published_at": "2015-08-17T18:55:36+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939c736e66", "title": "Waiting for 9.6 – Add psql \\ev and \\sv commands for editing and showing view definitions.", "url": "https://www.depesz.com/2015/07/21/waiting-for-9-6-add-psql-ev-and-sv-commands-for-editing-and-showing-view-definitions/", "published_at": "2015-07-21T18:27:47+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939d0adf70", "title": "Partitioning – what? why? how?", "url": "https://www.depesz.com/2015/06/07/partitioning-what-why-how/", "published_at": "2015-06-07T09:50:54+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939dd3d9d9", "title": "Filling in the blanks", "url": "https://www.depesz.com/2015/06/06/filling-in-the-blanks/", "published_at": "2015-06-06T16:43:21+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939ebb085f", "title": "Waiting for 9.5 – Rename jsonb_replace to jsonb_set and allow it to add new values", "url": "https://www.depesz.com/2015/06/04/waiting-for-9-5-rename-jsonb_replace-to-jsonb_set-and-allow-it-to-add-new-values/", "published_at": "2015-06-04T18:11:02+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939ee665e5", "title": "New functionality on explain.depesz.com, and some statistics", "url": "https://www.depesz.com/2015/06/03/new-functionality-on-explain-depesz-com-and-some-statistics/", "published_at": "2015-06-03T09:59:05+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939f6f1710", "title": "Waiting for 9.5 – Support GROUPING SETS, CUBE and ROLLUP.", "url": "https://www.depesz.com/2015/05/24/waiting-for-9-5-support-grouping-sets-cube-and-rollup/", "published_at": "2015-05-24T00:16:08+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939f7a820a", "title": "Waiting for 9.5 – TABLESAMPLE, SQL Standard and extensible", "url": "https://www.depesz.com/2015/05/23/waiting-for-9-5-tablesample-sql-standard-and-extensible/", "published_at": "2015-05-23T00:35:00+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f7939fd485f0", "title": "Waiting for 9.5 – Add pg_audit, an auditing extension", "url": "https://www.depesz.com/2015/05/22/waiting-for-9-5-add-pg_audit-an-auditing-extension/", "published_at": "2015-05-22T01:01:33+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a065f1d9", "title": "Waiting for 9.5 – Add pg_settings.pending_restart column", "url": "https://www.depesz.com/2015/05/21/waiting-for-9-5-add-pg_settings-pending_restart-column/", "published_at": "2015-05-21T00:47:58+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a085ce8e", "title": "Waiting for 9.5 – Additional functions and operators for jsonb", "url": "https://www.depesz.com/2015/05/20/waiting-for-9-5-additional-functions-and-operators-for-jsonb/", "published_at": "2015-05-20T13:26:00+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a0e2a86d", "title": "Waiting for 9.5 – Add system view pg_stat_ssl", "url": "https://www.depesz.com/2015/05/11/waiting-for-9-5-add-system-view-pg_stat_ssl/", "published_at": "2015-05-11T20:40:39+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a15d7a6f", "title": "How to setup SSL connections and authentication?", "url": "https://www.depesz.com/2015/05/11/how-to-setup-ssl-connections-and-authentication/", "published_at": "2015-05-11T20:31:03+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a258ecbb", "title": "Waiting for 9.5 – Add support for INSERT … ON CONFLICT DO NOTHING/UPDATE.", "url": "https://www.depesz.com/2015/05/10/waiting-for-9-5-add-support-for-insert-on-conflict-do-nothingupdate/", "published_at": "2015-05-10T12:56:36+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a2cd6e43", "title": "Waiting for 9.5 – Add transforms feature", "url": "https://www.depesz.com/2015/05/03/waiting-for-9-5-add-transforms-feature/", "published_at": "2015-05-03T16:06:36+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a3b619a3", "title": "Waiting for 9.5 – Reduce lock levels of some trigger DDL and add FKs", "url": "https://www.depesz.com/2015/04/23/waiting-for-9-5-reduce-lock-levels-of-some-trigger-ddl-and-add-fks/", "published_at": "2015-04-23T19:55:55+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a3e0030b", "title": "Waiting for 9.5 – psql: add asciidoc output format", "url": "https://www.depesz.com/2015/04/07/waiting-for-9-5-psql-add-asciidoc-output-format/", "published_at": "2015-04-07T08:21:20+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a48d71e1", "title": "Waiting for 9.5 – Add stats for min, max, mean, stddev times to pg_stat_statements.", "url": "https://www.depesz.com/2015/04/06/waiting-for-9-5-add-stats-for-min-max-mean-stddev-times-to-pg_stat_statements/", "published_at": "2015-04-06T09:09:26+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a4dae43b", "title": "Waiting for 9.5 – Add support for index-only scans in GiST.", "url": "https://www.depesz.com/2015/04/05/waiting-for-9-5-add-support-for-index-only-scans-in-gist/", "published_at": "2015-04-05T10:55:07+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a5d0e4b4", "title": "Waiting for 9.5 – Add pg_rewind, for re-synchronizing a master server after failback.", "url": "https://www.depesz.com/2015/04/04/waiting-for-9-5-add-pg_rewind-for-re-synchronizing-a-master-server-after-failback/", "published_at": "2015-04-04T12:13:32+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a63922ef", "title": "Waiting for 9.5 – Allow foreign tables to participate in inheritance. – A.K.A. PostgreSQL got sharding.", "url": "https://www.depesz.com/2015/04/02/waiting-for-9-5-allow-foreign-tables-to-participate-in-inheritance/", "published_at": "2015-04-02T19:30:10+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a705cd51", "title": "Waiting for 9.5 – Use 128-bit math to accelerate some aggregation functions.", "url": "https://www.depesz.com/2015/04/01/waiting-for-9-5-use-128-bit-math-to-accelerate-some-aggregation-functions/", "published_at": "2015-04-01T20:22:34+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a74965b7", "title": "Waiting for 9.5 – array_offset() and array_offsets()", "url": "https://www.depesz.com/2015/03/18/waiting-for-9-5-array_offset-and-array_offsets/", "published_at": "2015-03-18T20:28:52+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a840c65c", "title": "How to pg_upgrade …", "url": "https://www.depesz.com/2015/02/27/how-to-pg_upgrade/", "published_at": "2015-02-27T18:59:40+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a84b0e0c", "title": "Waiting for 9.5 – Replace checkpoint_segments with min_wal_size and max_wal_size.", "url": "https://www.depesz.com/2015/02/25/waiting-for-9-5-replace-checkpoint_segments-with-min_wal_size-and-max_wal_size/", "published_at": "2015-02-25T20:21:37+00:00" }, { "id": "01a0c56b-5fb3-7238-95d3-f793a87b8996", "title": "I have PostgreSQL, loaded some data, and have app using it. Now what?", "url": "https://www.depesz.com/2015/02/21/i-have-postgresql-loaded-some-data-and-have-app-using-it-now-what/", "published_at": "2015-02-21T12:13:30+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b330c0dd0", "title": "Returning data in multiple columns", "url": "https://www.depesz.com/2015/02/04/returning-data-in-multiple-columns/", "published_at": "2015-02-04T15:46:18+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b33b33f3c", "title": "Fixed a bug in OmniPITR", "url": "https://www.depesz.com/2015/02/03/fixed-a-bug-in-omnipitr/", "published_at": "2015-02-03T20:34:03+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b34a91fe2", "title": "Waiting for 9.5 – Use abbreviated keys for faster sorting of text datums.", "url": "https://www.depesz.com/2015/01/27/waiting-for-9-5-use-abbreviated-keys-for-faster-sorting-of-text-datums/", "published_at": "2015-01-27T00:37:46+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b34c5ff1a", "title": "Waiting for 9.5 – vacuumdb: enable parallel mode", "url": "https://www.depesz.com/2015/01/26/waiting-for-9-5-vacuumdb-enable-parallel-mode/", "published_at": "2015-01-26T13:46:35+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3537c973", "title": "Reloading of Perl script while it’s running", "url": "https://www.depesz.com/2015/01/21/reloading-of-perl-script-while-its-running/", "published_at": "2015-01-21T20:19:37+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b35bb2b5d", "title": "Changes in explain.depesz.com", "url": "https://www.depesz.com/2015/01/08/changes-in-explain-depesz-com/", "published_at": "2015-01-08T21:17:00+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3691f8f7", "title": "Waiting for 9.5 – Add point polygon distance operator.", "url": "https://www.depesz.com/2014/12/24/waiting-for-9-5-add-point-polygon-distance-operator/", "published_at": "2014-12-24T11:50:11+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b37447e32", "title": "Waiting for 9.5 – REINDEX SCHEMA", "url": "https://www.depesz.com/2014/12/09/waiting-for-9-5-reindex-schema/", "published_at": "2014-12-09T06:20:58+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b380235e8", "title": "Waiting for 9.5 – Event Trigger for table_rewrite", "url": "https://www.depesz.com/2014/12/08/waiting-for-9-5-event-trigger-for-table_rewrite/", "published_at": "2014-12-08T21:14:57+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b38d82946", "title": "How much slower are numerics?", "url": "https://www.depesz.com/2014/12/06/how-much-slower-are-numerics/", "published_at": "2014-12-06T18:47:33+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b39820457", "title": "My personal PostgreSQL Wish List", "url": "https://www.depesz.com/2014/11/26/my-personal-postgresql-wish-list/", "published_at": "2014-11-26T03:19:01+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3a3b98ef", "title": "Waiting for 9.5 – Support arrays as input to array_agg() and ARRAY(SELECT …).", "url": "https://www.depesz.com/2014/11/25/waiting-for-9-5-support-arrays-as-input-to-array_agg-and-arrayselect/", "published_at": "2014-11-25T21:32:08+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3a5fe8d3", "title": "Waiting for 9.5 – Add generate_series(numeric, numeric).", "url": "https://www.depesz.com/2014/11/23/waiting-for-9-5-add-generate_seriesnumeric-numeric/", "published_at": "2014-11-23T02:40:04+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3ad8e493", "title": "Zombicide – pilot rescue", "url": "https://www.depesz.com/2014/11/22/zombicide-pilot-rescue/", "published_at": "2014-11-22T18:39:47+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3b9cd613", "title": "Waiting for 9.5 – BRIN: Block Range Indexes.", "url": "https://www.depesz.com/2014/11/22/waiting-for-9-5-brin-block-range-indexes/", "published_at": "2014-11-22T11:09:22+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3c190c76", "title": "How to install your own copy of explain.depesz.com", "url": "https://www.depesz.com/2014/11/06/how-to-install-your-own-copy-of-explain-depesz-com/", "published_at": "2014-11-06T06:22:01+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3d00222c", "title": "Changes on explain.depesz.com", "url": "https://www.depesz.com/2014/11/05/changes-on-explain-depesz-com-4/", "published_at": "2014-11-05T15:43:14+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3d1425b2", "title": "PostgreSQL + Perl + Unicode == confusion. Why?", "url": "https://www.depesz.com/2014/10/19/postgresql-perl-unicode-confusion-why/", "published_at": "2014-10-19T13:06:20+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3de42206", "title": "What logging has least overhead?", "url": "https://www.depesz.com/2014/10/14/what-logging-has-least-overhead/", "published_at": "2014-10-14T12:45:48+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3e2ca465", "title": "Waiting for 9.5 – Implement SKIP LOCKED for row-level locks", "url": "https://www.depesz.com/2014/10/10/waiting-for-9-5-implement-skip-locked-for-row-level-locks/", "published_at": "2014-10-10T18:35:29+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3ed728c0", "title": "Waiting for 9.5 – Row-Level Security Policies (RLS)", "url": "https://www.depesz.com/2014/10/02/waiting-for-9-5-row-level-security-policies-rls/", "published_at": "2014-10-02T19:28:13+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3ef23b1e", "title": "Waiting for 9.5 – Add width_bucket(anyelement, anyarray).", "url": "https://www.depesz.com/2014/09/14/waiting-for-9-5-add-width_bucketanyelement-anyarray/", "published_at": "2014-09-14T20:33:11+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b3f9db0a6", "title": "Waiting for 9.5 – Add psql PROMPT variable showing which line of a statement is being edited.", "url": "https://www.depesz.com/2014/09/05/waiting-for-9-5-add-psql-prompt-variable-showing-which-line-of-a-statement-is-being-edited/", "published_at": "2014-09-05T06:13:44+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b40641eae", "title": "Waiting for 9.5 – Support ALTER SYSTEM RESET command.", "url": "https://www.depesz.com/2014/09/04/waiting-for-9-5-support-alter-system-reset-command/", "published_at": "2014-09-04T04:17:06+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b410611ed", "title": "Waiting for 9.5 – Add min and max aggregates for inet/cidr data types.", "url": "https://www.depesz.com/2014/09/03/waiting-for-9-5-add-min-and-max-aggregates-for-inetcidr-data-types/", "published_at": "2014-09-03T02:28:21+00:00" }, { "id": "01a0c574-c144-7223-8e5c-026b41bb9e2b", "title": "Waiting for 9.5 – Implement ALTER TABLE .. SET LOGGED / UNLOGGED", "url": "https://www.depesz.com/2014/09/01/waiting-for-9-5-implement-alter-table-set-logged-unlogged/", "published_at": "2014-09-01T19:10:54+00:00" }, { "id": "01a0c574-c145-70bf-a33a-b9e1a9598cba", "title": "Waiting for 9.5 – psql: Show tablespace size in \\db+", "url": "https://www.depesz.com/2014/07/15/waiting-for-9-5-psql-show-tablespace-size-in-db/", "published_at": "2014-07-15T20:28:47+00:00" }, { "id": "01a0c574-c145-70bf-a33a-b9e1a9faf030", "title": "Waiting for 9.5 – Implement IMPORT FOREIGN SCHEMA.", "url": "https://www.depesz.com/2014/07/14/waiting-for-9-5-implement-import-foreign-schema/", "published_at": "2014-07-14T20:47:06+00:00" }, { "id": "01a0c574-c145-70bf-a33a-b9e1aa4df75e", "title": "Waiting for 9.5 – Add cluster_name GUC which is included in process titles if set.", "url": "https://www.depesz.com/2014/07/02/waiting-for-9-5-add-cluster_name-guc-which-is-included-in-process-titles-if-set/", "published_at": "2014-07-02T20:17:08+00:00" }, { "id": "01a0c574-c145-70bf-a33a-b9e1aaa4a087", "title": "Waiting for 9.5 – Implement UPDATE tab SET (col1,col2,…) = (SELECT …), …", "url": "https://www.depesz.com/2014/06/21/waiting-for-9-5-implement-update-tab-set-col1col2-select/", "published_at": "2014-06-21T14:30:08+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c366c3fa9f", "title": "Anonymize CTE names on explain.depesz.com", "url": "https://www.depesz.com/2014/06/08/anonymize-cte-names-on-explain-depesz-com/", "published_at": "2014-06-08T00:01:36+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c36706ccc5", "title": "Joining BTree and GIN/GiST indexes", "url": "https://www.depesz.com/2014/05/12/joining-btree-and-gingist-indexes/", "published_at": "2014-05-12T21:52:13+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c367c4ae6f", "title": "Waiting for 9.4 – Add support for wrapping to psql’s “extended” mode.", "url": "https://www.depesz.com/2014/05/05/waiting-for-9-4-add-support-for-wrapping-to-psqls-extended-mode/", "published_at": "2014-05-05T18:39:06+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c367cddf59", "title": "Waiting for 9.4 – Provide moving-aggregate support for a bunch of aggregates.", "url": "https://www.depesz.com/2014/04/13/waiting-for-9-4-provide-moving-aggregate-support-for-a-bunch-of-aggregates/", "published_at": "2014-04-13T12:13:20+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c3683396b3", "title": "How to deal with timestamps?", "url": "https://www.depesz.com/2014/04/04/how-to-deal-with-timestamps/", "published_at": "2014-04-04T19:31:58+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c368be406a", "title": "Waiting for 9.4 – Introduce jsonb, a structured format for storing json.", "url": "https://www.depesz.com/2014/03/25/waiting-for-9-4-introduce-jsonb-a-structured-format-for-storing-json/", "published_at": "2014-03-25T20:48:10+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c36980d9dc", "title": "Waiting for 9.4 – auto_explain: Add logging of trigger execution", "url": "https://www.depesz.com/2014/03/11/waiting-for-9-4-auto_explain-add-logging-of-trigger-execution/", "published_at": "2014-03-11T19:25:04+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c369d547ee", "title": "Waiting for 9.4 – Constructors for interval, timestamp, timestamptz", "url": "https://www.depesz.com/2014/03/07/waiting-for-9-4-constructors-for-interval-timestamp-timestamptz/", "published_at": "2014-03-07T20:25:07+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c36a5943cd", "title": "Waiting for 9.4 – Introduce logical decoding", "url": "https://www.depesz.com/2014/03/06/waiting-for-9-4-introduce-logical-decoding/", "published_at": "2014-03-06T20:27:12+00:00" }, { "id": "01a0c582-88b3-70ee-8a4a-48c36acf26db", "title": "Waiting for 9.4 – Allow BASE_BACKUP to be throttled", "url": "https://www.depesz.com/2014/03/05/waiting-for-9-4-allow-base_backup-to-be-throttled/", "published_at": "2014-03-05T20:33:59+00:00" } ] posts Claim your blog
Back to Hubert Lubaczewski
Blog · corpus.blog/blogs/depesz.com/posts

Hubert Lubaczewski

depesz.com

2016

Waiting for 9.6 – Support \crosstabview in psqloriginal ↗
27 Apr 2016
Waiting for 9.6 – Phrase full text search.original ↗
22 Apr 2016
Waiting for 9.6 – Add a \gexec command to psql for evaluation of computed queries.original ↗
22 Apr 2016
Waiting for 9.6 – Bloom index contrib moduleoriginal ↗
11 Apr 2016
Change on explain.depesz.comoriginal ↗
5 Apr 2016
Waiting for 9.6 – Support parallel aggregation.original ↗
23 Mar 2016
Waiting for 9.6 – Directly modify foreign tables.original ↗
22 Mar 2016
Waiting for 9.6 – Add idle_in_transaction_session_timeout.original ↗
22 Mar 2016
Waiting for 9.6 – Add simple VACUUM progress reporting.original ↗
22 Mar 2016
Waiting for 9.6 – Tsvector editing functionsoriginal ↗
21 Mar 2016
Waiting for 9.6 – Add a generic command progress reporting facility.original ↗
9 Mar 2016
Waiting for 9.6 – Add new system view, pg_configoriginal ↗
29 Feb 2016
Waiting for 9.6 – Remove GROUP BY columns that are functionally dependent on other columns.original ↗
16 Feb 2016
explain.depesz.com – new change and some statsoriginal ↗
8 Feb 2016
Waiting for 9.6 – Add num_nulls() and num_nonnulls() to count NULL arguments.original ↗
8 Feb 2016
Waiting for 9.6 – Add trigonometric functions that work in degrees.original ↗
1 Feb 2016
Waiting for 9.6 – Support parallel joins, and make related improvements.original ↗
1 Feb 2016
Waiting for 9.6 – Allow to omit boundaries in array subscriptoriginal ↗
10 Jan 2016
Waiting for 9.6 – Cube extension kNN supportoriginal ↗
10 Jan 2016

2015

Waiting for 9.6 – Allow EXPLAIN (ANALYZE, VERBOSE) to display per-worker statistics.original ↗
15 Dec 2015
Waiting for 9.6 – psql: Support multiple -c and -f options, and allow mixing them.original ↗
14 Dec 2015
Grouping data by timestamp and intervaloriginal ↗
8 Dec 2015
Waiting for 9.6 – Generate parallel sequential scan plans in simple cases.original ↗
17 Nov 2015
Waiting for 9.6 – Implement lookbehind constraints in our regular-expression engine.original ↗
17 Nov 2015
Is C faster for (instagram-style) ID generation?original ↗
30 Oct 2015
explain.depesz.com changes and new statsoriginal ↗
13 Oct 2015
Waiting for 9.6 – Add CASCADE support for CREATE EXTENSION.original ↗
8 Oct 2015
Converting Logical Volume so that it’s stripedoriginal ↗
8 Oct 2015
Waiting for 9.6 – Allow per-tablespace effective_io_concurrencyoriginal ↗
22 Sept 2015
Waiting for 9.6 – Add log_line_prefix option ‘n’ for Unix epoch.original ↗
22 Sept 2015
Waiting for 9.6 – Allow usage of huge maintenance_work_mem for GIN build.original ↗
15 Sept 2015
Hypothetical indexesoriginal ↗
7 Sept 2015
Waiting for 9.6 – Add IF NOT EXISTS processing to ALTER TABLE ADD COLUMNoriginal ↗
19 Aug 2015
Waiting for 9.6 – Add new function pg_notification_queue_usage.original ↗
18 Aug 2015
Waiting for 9.6 – Add psql PROMPT variable showing the pid of the connected to backend.original ↗
17 Aug 2015
Waiting for 9.6 – Add psql \ev and \sv commands for editing and showing view definitions.original ↗
21 Jul 2015
Partitioning – what? why? how?original ↗
7 Jun 2015
Filling in the blanksoriginal ↗
6 Jun 2015
Waiting for 9.5 – Rename jsonb_replace to jsonb_set and allow it to add new valuesoriginal ↗
4 Jun 2015
New functionality on explain.depesz.com, and some statisticsoriginal ↗
3 Jun 2015
Waiting for 9.5 – Support GROUPING SETS, CUBE and ROLLUP.original ↗
24 May 2015
Waiting for 9.5 – TABLESAMPLE, SQL Standard and extensibleoriginal ↗
23 May 2015
Waiting for 9.5 – Add pg_audit, an auditing extensionoriginal ↗
22 May 2015
Waiting for 9.5 – Add pg_settings.pending_restart columnoriginal ↗
21 May 2015
Waiting for 9.5 – Additional functions and operators for jsonboriginal ↗
20 May 2015
Waiting for 9.5 – Add system view pg_stat_ssloriginal ↗
11 May 2015
How to setup SSL connections and authentication?original ↗
11 May 2015
Waiting for 9.5 – Add support for INSERT … ON CONFLICT DO NOTHING/UPDATE.original ↗
10 May 2015
Waiting for 9.5 – Add transforms featureoriginal ↗
3 May 2015
Waiting for 9.5 – Reduce lock levels of some trigger DDL and add FKsoriginal ↗
23 Apr 2015
Waiting for 9.5 – psql: add asciidoc output formatoriginal ↗
7 Apr 2015
Waiting for 9.5 – Add stats for min, max, mean, stddev times to pg_stat_statements.original ↗
6 Apr 2015
Waiting for 9.5 – Add support for index-only scans in GiST.original ↗
5 Apr 2015
Waiting for 9.5 – Add pg_rewind, for re-synchronizing a master server after failback.original ↗
4 Apr 2015
Waiting for 9.5 – Allow foreign tables to participate in inheritance. – A.K.A. PostgreSQL got sharding.original ↗
2 Apr 2015
Waiting for 9.5 – Use 128-bit math to accelerate some aggregation functions.original ↗
1 Apr 2015
Waiting for 9.5 – array_offset() and array_offsets()original ↗
18 Mar 2015
How to pg_upgrade …original ↗
27 Feb 2015
Waiting for 9.5 – Replace checkpoint_segments with min_wal_size and max_wal_size.original ↗
25 Feb 2015
I have PostgreSQL, loaded some data, and have app using it. Now what?original ↗
21 Feb 2015
Returning data in multiple columnsoriginal ↗
4 Feb 2015
Fixed a bug in OmniPITRoriginal ↗
3 Feb 2015
Waiting for 9.5 – Use abbreviated keys for faster sorting of text datums.original ↗
27 Jan 2015
Waiting for 9.5 – vacuumdb: enable parallel modeoriginal ↗
26 Jan 2015
Reloading of Perl script while it’s runningoriginal ↗
21 Jan 2015
Changes in explain.depesz.comoriginal ↗
8 Jan 2015

2014

Waiting for 9.5 – Add point polygon distance operator.original ↗
24 Dec 2014
Waiting for 9.5 – REINDEX SCHEMAoriginal ↗
9 Dec 2014
Waiting for 9.5 – Event Trigger for table_rewriteoriginal ↗
8 Dec 2014
How much slower are numerics?original ↗
6 Dec 2014
My personal PostgreSQL Wish Listoriginal ↗
26 Nov 2014
Waiting for 9.5 – Support arrays as input to array_agg() and ARRAY(SELECT …).original ↗
25 Nov 2014
Waiting for 9.5 – Add generate_series(numeric, numeric).original ↗
23 Nov 2014
Zombicide – pilot rescueoriginal ↗
22 Nov 2014
Waiting for 9.5 – BRIN: Block Range Indexes.original ↗
22 Nov 2014
How to install your own copy of explain.depesz.comoriginal ↗
6 Nov 2014
Changes on explain.depesz.comoriginal ↗
5 Nov 2014
PostgreSQL + Perl + Unicode == confusion. Why?original ↗
19 Oct 2014
What logging has least overhead?original ↗
14 Oct 2014
Waiting for 9.5 – Implement SKIP LOCKED for row-level locksoriginal ↗
10 Oct 2014
Waiting for 9.5 – Row-Level Security Policies (RLS)original ↗
2 Oct 2014
Waiting for 9.5 – Add width_bucket(anyelement, anyarray).original ↗
14 Sept 2014
Waiting for 9.5 – Add psql PROMPT variable showing which line of a statement is being edited.original ↗
5 Sept 2014
Waiting for 9.5 – Support ALTER SYSTEM RESET command.original ↗
4 Sept 2014
Waiting for 9.5 – Add min and max aggregates for inet/cidr data types.original ↗
3 Sept 2014
Waiting for 9.5 – Implement ALTER TABLE .. SET LOGGED / UNLOGGEDoriginal ↗
1 Sept 2014
Waiting for 9.5 – psql: Show tablespace size in \db+original ↗
15 Jul 2014
Waiting for 9.5 – Implement IMPORT FOREIGN SCHEMA.original ↗
14 Jul 2014
Waiting for 9.5 – Add cluster_name GUC which is included in process titles if set.original ↗
2 Jul 2014
Waiting for 9.5 – Implement UPDATE tab SET (col1,col2,…) = (SELECT …), …original ↗
21 Jun 2014
Anonymize CTE names on explain.depesz.comoriginal ↗
8 Jun 2014
Joining BTree and GIN/GiST indexesoriginal ↗
12 May 2014
Waiting for 9.4 – Add support for wrapping to psql’s “extended” mode.original ↗
5 May 2014
Waiting for 9.4 – Provide moving-aggregate support for a bunch of aggregates.original ↗
13 Apr 2014
How to deal with timestamps?original ↗
4 Apr 2014
Waiting for 9.4 – Introduce jsonb, a structured format for storing json.original ↗
25 Mar 2014
Waiting for 9.4 – auto_explain: Add logging of trigger executionoriginal ↗
11 Mar 2014
Waiting for 9.4 – Constructors for interval, timestamp, timestamptzoriginal ↗
7 Mar 2014
Waiting for 9.4 – Introduce logical decodingoriginal ↗
6 Mar 2014
Waiting for 9.4 – Allow BASE_BACKUP to be throttledoriginal ↗
5 Mar 2014
Previous Next