Blog: depesz (Hubert Lubaczewski)


210 blogs updated: 5 min. ago
Waiting for PostgreSQL 11 – Transforms for jsonb to PL/Python and to PL/Perl
On 28th of March 2018, Peter Eisentraut committed patch: Transforms for jsonb to PL/Python Add a new contrib module jsonb_plpython that prov...
10
17-04-2018 21:33:33 depesz (Hubert Lubaczewski) PostgreSQL
paste.depesz.com is back (for good?)
Some time ago I removed paste.depesz.com because of some problems with underlying formatting library. Now, it's back. New code, new approach...
7
13-04-2018 15:55:34 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 11 – MERGE SQL Command following SQL:2016
On 2nd of April 2018, Simon Riggs committed patch: MERGE SQL Command following SQL:2016 MERGE performs actions that modify rows in the targe...
10
10-04-2018 21:16:02 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default
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 ta...
15
04-04-2018 19:17:20 depesz (Hubert Lubaczewski) PostgreSQL
paste.depesz.com is no more
Some time ago I wrote a site to paste SQL queries with reformatting/pretty-print ing using pgFormatter library. Today, I figured out that I ...
4
12-03-2018 12:15:55 depesz (Hubert Lubaczewski) PostgreSQL
What is the benefit of upgrading PostgreSQL?
Couple of times, in various places, I was asked: what is the benefit from upgrading to some_version. So far, I just read release docs, and c...
15
22-02-2018 20:27:36 depesz (Hubert Lubaczewski) PostgreSQL
Which schema is using the most disk space?
I was faced with interesting problem. Which schema, in my DB, uses the most disk space? Theoretically it's trivial, we have set of helpful f...
10
17-02-2018 14:09:33 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 11 – Support all SQL:2011 options for window frame clauses.
On 7th of February 2018, Tom Lane committed patch: Support all SQL:2011 options for window frame clauses. This patch adds the ability to use...
10
13-02-2018 14:59:10 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 11 – Support parallel btree index builds.
Support parallel btree index builds. To make this work, tuplesort.c and logtape.c must also support parallelism, so this patch adds that inf...
13
12-02-2018 16:21:27 depesz (Hubert Lubaczewski) PostgreSQL
Fix for parallel scans on explain.depesz.com
On Friday, Zr40 reported on irc that explain.depesz.com doesn't show table/index names for Parallel Seq Scan nodes. Checked it and found cou...
16
05-02-2018 13:48:04 depesz (Hubert Lubaczewski) PostgreSQL


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.