On Saturday, 30th of June, Andrew Dunstan stamped HEAD in git as 12devel. This means that there will be no new features in Pg11. And now, my test Pg reports: =$ psql -c 'select version()' ...
June 25th, 2018 by depesz | Tags: partitioning, partitions, pg11, postgresql, prune, stable | No comments »
On 10th of June 2018, Tom Lane committed patch: Improve run-time partition pruning to handle any stable expression. The initial coding of the run-time-pruning feature only coped with cases where the partition key(s) are compared to Params. That is a bit silly; we ...
June 7th, 2018 by depesz | | 5 comments »
As you perhaps know, recently GitHub was acquired by Microsoft. I'm not really a fan of Microsoft, so decided to migrate my project away. So, all my projects have been moved to GitLab.
May 1st, 2018 by depesz | Tags: executor, partitioning, partitions, performance, pg11, planner, postgresql, prune | No comments »
On 7th of April 2018, Alvaro Herrera committed patch: Support partition pruning at execution time Existing partition pruning is only able to work at plan time, for query quals that appear in the parsed query. This is good but limiting, as there can ...
April 26th, 2018 by depesz | Tags: covering, index, index-only, pg11, postgresql, scan | 4 comments »
On 7th of April 2018, Teodor Sigaev committed patch: Indexes with INCLUDE columns and their support in B-tree This patch introduces INCLUDE clause to index definition. This clause specifies a list of columns which will be included as a non-key part in the ...
On 7th of April 2018, Teodor Sigaev committed patch: Add json(b)_to_tsvector function Jsonb has a complex nature so there isn't best-for-everything way to convert it to tsvector for full text search. Current to_tsvector(json(b)) suggests to convert only string values, but it's possible to index ...
April 17th, 2018 by depesz | Tags: jsonb, pg11, plperl, plperlu, plpython, plpythonu, postgresql, transform | 1 comment »
On 28th of March 2018, Peter Eisentraut committed patch: Transforms for jsonb to PL/Python Add a new contrib module jsonb_plpython that provide a transform between jsonb and PL/Python. jsonb values are converted to appropriate Python types such as dicts and lists, and vice ...
April 13th, 2018 by depesz | Tags: paste, paste.depesz.com, pgFormatter, pg_query, postgresql, ruby | 2 comments »
Some time ago I removed paste.depesz.com because of some problems with underlying formatting library. Now, it's back. New code, new approach, hopefully usable site.
April 10th, 2018 by depesz | Tags: merge, oltp, pg11, postgresql, standard, transform, upsert | 1 comment »
update! It looks that this has been reverted On 2nd of April 2018, Simon Riggs committed patch: MERGE SQL Command following SQL:2016 MERGE performs actions that modify rows in the target table using a source table or query. MERGE provides a single SQL statement that can ...
April 4th, 2018 by depesz | Tags: add, column, default, performance, pg11, postgresql | 8 comments »
On 28th of March 2018, Andrew Dunstan committed patch: Fast ALTER TABLE ADD COLUMN with a non-NULL default Currently adding a column to a table with a non-NULL default results in a rewrite of the table. For large tables this can be both ...