Planet PostgreSQL
1
movead li: Have An Eye On Locks Of PostgreSQL  01h32 21 février
The lock is an essential part of a database system. In PostgreSQL, there are various locks, such as table lock, row lock, page lock, transaction lock, advisory lock, etc. Some of these locks are automatically added to complete the database functions during the operation of the database system, and...
2
Andreas ’ads’ Scherbaum: PGConf.DE 2020 - Registration open  13h00 20 février
PostgreSQL Conference Germany 2020 in Stuttgart, Germany, on May 15th is now open for registrations. The Call for Papers is already closed, and we are working with the last speakers to confirm their talks, and we will have a full schedule published soon. There are still a few EARLYBIRD tickets...
3
Magnus Hagander: Connecting to Azure PostgreSQL with libpq 12 in a Kerberos environment  10h26 20 février
If you are using Azure PostgreSQL and have upgraded your client side libpq to version 12 (which can happen automatically for example if you use the PostgreSQL apt repositories), you may see connection attempts fail with symptoms like: psql -hZZZZZZ.postgres.database.azure.com -dpostgres -UXXXXX...
4
Amit Kapila: Parallelism, what next?  11h07 19 février
This blog post is about the journey of parallelism in PostgreSQL till now and what is in store for the future. Since PostgreSQL 9.6 where the first feature of parallel query has arrived, each release improves it. Below is a brief overview of the parallel query features added in each...
5
Hans-Juergen Schoenig: shared buffers: Looking into the PostgreSQL I O cache  08h00 19 février
The PostgreSQL caching system has always been a bit of a miracle to many people and many have asked me during consulting or training sessions: How can I figure out what the PostgreSQL I O cache really contains? What is in shared buffers and how can one figure out? This post will answer this kind of...
6
Hubert ’depesz’ Lubaczewski: Why I’m not fan of uuid datatype  07h37 19 février
Recently, on irc, there were couple of cases where someone wanted to use uuid as datatype for their primary key. I opposed, and tried to explain, but IRC doesn’t really allow for longer texts, so figured I’ll write a blogpost. First problem – UUID values are completely opaque. That means...
7
Hubert ’depesz’ Lubaczewski: Fix for displaying aggregates on explain.depesz.com  16h41 18 février
Couple of days ago RhodiumToad reported, on irc, a bug in explain.depesz.com. Specifically – if explain was done using JSON XML YAML formats, and node type was Aggregate, the site didn’t extract full info. In text explains the node type is one of: Aggregate HashAggregate GroupAggregate But in...
8
Hubert ’depesz’ Lubaczewski: Which tables should be auto vacuumed or auto analyzed - UPDATE  12h45 18 février
Some time ago I wrote blogpost which showed how to list tables that should be autovacuumed or autoanalyzed. Query in there had one important problem – it didn’t take into account per-table settings. Specifically – it only used system-wide values for: autovacuum analyze scale factor...
9
Hubert ’depesz’ Lubaczewski: Waiting for PostgreSQL 13 - Add %x to default PROMPT1 and PROMPT2 in psql  20h07 17 février
On 12nd of February 2020, Michael Paquier committed patch: Add %x to default PROMPT1 and PROMPT2 in psql   %d can be used to track if the current connection is in a transaction block or not, and adding it by default to the prompt has the advantage to not need a modification of .psqlrc,...
10
Hubert ’depesz’ Lubaczewski: Waiting for PostgreSQL 13 - Add leader pid to pg stat activity  14h24 17 février
On 6th of February 2020, Michael Paquier committed patch: Add leader pid to pg stat activity   This new field tracks the PID of the group leader used with parallel query. For parallel workers and the leader, the value is set to the PID of the group leader. So, for the group leader, the value...
11
Daniel Vérité: Isolation Repeatable Read in PostgreSQL versus MySQL  18h14 14 février
To avoid having concurrent transactions interfere with each other, SQL engines implement isolation as a feature. This property corresponds to the I letter in the well known ACID acronym, the other properties being Atomicity, Consistency and Durability. Isolation happens to be configurable, with...
12
Pavel Stehule: plpgsql check 1.9 calculates coverage metrics  18h03 14 février
Small note - I finished support of statement and branch coverage metrics calculations for plpgsql checkhttps: github.com okbob plpgsql check commit c6f9896ead0a0969db23c3062f1fe7ce5f38029b
13
Ernst-Georg Schmid: Excel and ODF support for cloudfs fdw  10h53 14 février
cloudfs fdw now supports .xls (Excel 97-2003), .xlsx, and .ods (Open Document Format) Spreadsheets via pandas, xlrd, and odfpy. It requires pandas > 1.0.1, so Multicorn must be compiled against Python 3.Since pandas provides sorting and filtering capabilities, cloudfs fdw tries...
14
Robert Haas: Useless Vacuuming  19h13 13 février
In previous blog posts that I’ve written about VACUUM, and I seem to be accumulating an uncomfortable number of those, I’ve talked about various things that can go wrong with vacuum, but one that I haven’t really covered is when autovacuum seems to be running totally normally but you still have a...
15
Jobin Augustine: Compression of PostgreSQL WAL Archives Becoming More Important  14h54 13 février
As hardware and software evolve, the bottlenecks in a database system also shift. Many old problems might disappear and new types of problems pop-up. Old Limitations There were days when CPU and Memory was a limitation. More than a decade back, servers with 4 cores were “High End” and...