September 25th, 2018 by depesz | Tags: administrator, cancel, pg_terminator, postgresql, ruby, terminate | No comments »
I just released first version of pg_terminator. It's a tool that is supposed to be run on PostgreSQL db server, monitor a database, and cancel or terminate offending queries/connections. It can be used, for example to: kill leftover psql sessions that are not ...
August 13th, 2018 by depesz | Tags: copy, partitioning, partitions, performance, pg12, postgresql | No comments »
On 1st of August 2018, Peter Eisentraut committed patch: Allow multi-inserts during COPY into a partitioned table CopyFrom allows multi-inserts to be used for non-partitioned tables, but this was disabled for partitioned tables. The reason for this appeared to be that the tuple ...
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.