Sammlung von Newsfeeds
Robert Treat: 5 Quick Thoughts on the State of Postgres Survey
The folks at TimescaleDB have published their "State of Postgres" survey results in a new micro-site where you can find a summary of responses, some more detailed analysis, and the source data from the survey. This survey was conducted for about 2 months during the late summer/early fall of 2019 and while I haven't gone through all the raw data as of yet, after reading the results... well, I have some opinions.
Rafia Sabih: Interesting aspects of logical replication at a glance
Dmitry Dolgov: PostgreSQL at low level: stay curious!
Luca Ferrari: PostgreSQL 12 EXPLAIN SETTINGS
PostgreSQL 12 has a very interesting feature to turn on when doing an execution plan analysis.
PostgreSQL 12 EXPLAIN SETTINGS
PostgreSQL 12 has a new feature that can be turned on in the EXPLAIN output: SETTINGS. This option provides some information about all and only those parameters that can affect an execution plan if and only if they are not at the default setting.
What does it mean in practice? Let’s see an old plain EXPLAIN:
Hans-Juergen Schoenig: Abusing PostgreSQL as an SQL beautifier
SQL is query a language that is usually pretty easy to read. However, if people don’t format their queries properly even SQL turn out to be a nightmare. That’s why developers often turn to an SQL beautifier to turn an ugly query into a nicely formatted string. Various tools are available on the web to achieve exactly that.
Can the same thing be achieved using only PostgreSQL onboard tools? The answer is yes. This post will show you how to achieve that.
Hubert 'depesz' Lubaczewski: Changes on explain.depesz.com
Jobin Augustine: PostgreSQL 12 Improvement: Benign Log Entries “Incomplete Startup Packet”
There is a less-talked-about improvement in PostgreSQL 12 which can greatly reduce the benign log entries. This patch is probably one of the smallest in PostgreSQL 12.
The commit message says:
Dimitri Fontaine: Black Friday & Cyber Monday
Kaarel Moppel: Discovering less-known PostgreSQL v12 features
Version 12 of PostgreSQL is not exactly fresh out of the oven, as the first minor release was already announced. However, I think it’s fair to say that this version can be still considered fresh for most users, and surely only a small percentage of users has upgraded. So I think it makes sense to go over some new features. This will be my last article beating on the v12 drum though, I promise
Peter Eisentraut: Setting SSL/TLS protocol versions with PostgreSQL 12
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – Allow invisible PROMPT2 in psql.
Laurenz Albe: B-tree index improvements in PostgreSQL v12
Image © Laurenz Albe 2019
If you thought that the B-tree index is a technology that was perfected in the 1980s, you are mostly right. But there is still room for improvement, so PostgreSQL v12 (in the tradition of v11) has added some new features in this field. Thanks, Peter Geoghegan!
In this article, I want to explain some of these improvements with examples.
Rafia Sabih: Which size fits me?
Rajeev Rastogi: An Overview of VACUUM Processing in PostgreSQL
PostgreSQL does not use IN-PLACE update mechanism, so as per the way DELETE and UPDATE command is designed,
Pavel Stehule: Compilation Orafce on CentOS 7 against pgdg repo
with_llvm=no make -e
Beena Emerson: Using PQtrace
Hugo Dias: PostgreSQL Deployment & Configuration with Puppet
Puppet is open source software for configuration management and deployment. Founded in 2005, it’s multi-platform and even has its own declarative language for configuration.