Blog: depesz (Hubert Lubaczewski)


210 blogs updated: 71 min. ago
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
Waiting for PostgreSQL 11 – Allow UPDATE to move rows between partitions.
On 19th of January 2018, Robert Haas committed patch: Allow UPDATE to move rows between partitions. When an UPDATE causes a row to no longer...
20
22-01-2018 20:13:36 depesz (Hubert Lubaczewski) PostgreSQL
Changes on explain.depesz.com
Bricklen Anderson reported a problem with explains that were using parallel processing. TL;DR: in case of parallel plans make "inclusive" an...
15
29-11-2017 19:09:15 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 11 – Add hash partitioning.
On 9th of November 2017, Robert Haas committed patch: Add hash partitioning. Hash partitioning is useful when you want to partition a growin...
26
10-11-2017 14:36:14 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 11 – Add psql variables to track success/failure of SQL queries.
On 12nd of September 2017, Tom Lane committed patch: Add psql variables to track success/failure of SQL queries. This patch adds ERROR, SQLS...
12
21-09-2017 22:38:15 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 11 – Add \gdesc psql command.
On 5th of September 2017, Tom Lane committed patch: Add \gdesc psql command. This command acts somewhat like \g, but instead of executing th...
12
21-09-2017 16:05:13 depesz (Hubert Lubaczewski) PostgreSQL
New functions in versioning
Long time ago I wrote about my project Versioning. Since then nothing really changed. But recently I found a case where I could use some mor...
7
07-08-2017 17:15:56 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.