Planet PostgreSQL
1
Craig Kerstiens: Postgres tips for the average and power user  14h05 17 juillet
Personally I’m a big fan of email, just like blogging. To me a good email thread can be like a good novel where you’re following along always curious for what comes next. And no, I don’t mean the ones where there is an email to all-employees company.com and someone replies all, to only receive...
2
Kaarel Moppel: The mysterious backend flush after configuration setting  07h30 17 juillet
The above-mentioned PostgreSQL server configuration parameter was introduced already some time ago, in version 9.6, but has been flying under the radar so to say and had not caught my attention previously. Until I recently was pasted (not being on Twitter) a tweet from one of the Postgres core...
3
Luca Ferrari: Suggesting Single-Column Primary Keys (almost) Automatically  00h00 17 juillet
Is it possible to infer primary keys automatically? If it, I’m not able at doing that, but at least I can try. Suggesting Single-Column Primary Keys (almost) Automatically A comment on my previous blog post about generating primary keys with a procedure made me think about how to inspect a table to...
4
Jobin Augustine: BRIN Index for PostgreSQL: Don’t Forget the Benefits  16h30 16 juillet
BRIN Index was introduced in PostgreSQL 9.5, but many users postponed the usage of it in their design and development just because it was new . But now we understand that it has stood the test-of-time It is time to reconsider BRIN if you have not done it yet. I often see users who forget there...
5
Kirk Roybal: Partitioning enhancements in PostgreSQL 12  16h18 15 juillet
Declarative partitioning got some attention in the PostgreSQL 12 release, with some very handy features. There has been some pretty dramatic improvement in partition selection (especially when selecting from a few partitions out of a large set), referential integrity improvements, and introspection...
6
Jonathan Katz: How to Upgrade Your PostgreSQL Passwords to SCRAM  18h27 12 juillet
In a lot of PostgreSQL environments, it’s common practice to protect user accounts with a password. Starting with PostgreSQL 10, the way PostgreSQL manages password-based authentication got a major upgrade with the introduction of SCRAM authentication, a well-defined standard that is a significant...
7
Kaarel Moppel: Implementing Autonomous Transactions in Postgres  07h30 12 juillet
Having recently witnessed quite an ingenious hack to implement some good old “println” style development debugging from stored procedures into a file, it prompted me to post knowledge to the Interwebs on two other ways how such a goal can be implemented more transparently. Also with...
8
Magnus Hagander: PGConf.EU 2019 - Registration and training open  15h19 11 juillet
PostgreSQL Conference Europe 2019 in Milan, Italy, on October 15-18 is now open for registrations. The Tuesday training sessions have also been finalized, and are now available for registration. Six sessions in a mix of full and half day sessions are available. Training sessions are available at...
9
Vasilis Ventirozos: Comparing pg 9.4 with pg 12, CTE edition  13h14 11 juillet
Postgres 12 is around the corner, and as always is packed with new features. One of them being the option to allow the user to control the behaviour of CTE materialization. You can find the commit from Tom Lane here, which explains everything about this new change but TLDR is that so far, CTE’s...
10
Jobin Augustine: PostgreSQL WAL Retention and Clean Up: pg archivecleanup  14h44 10 juillet
WAL retention is a very important topic for PostgreSQL database management. But very often we come across DBAs getting into surprise situations such as:1. Several TBs of WALs piled up in archive destination2. WALs filling up pg wal pg xlog directory due to failing archive3. Necessary WALs are no...
11
Dave Page: Reverse Proxying to pgAdmin  12h33 10 juillet
Reverse proxying requests to a pgAdmin server is becoming more and more popular if posts to the mailing lists are to be taken as an indicative measure; more often than not when using pgAdmin in a container (of which there have now been over 10 million pulls) Typically users will deploy a reverse...
12
Paul Ramsey: Serving Dynamic Vector Tiles from PostGIS  19h09 09 juillet
One of the most popular features of PostGIS 2.5 was the introduction of the vector tile output format, via the ST AsMVT() function.
13
Laurenz Albe: ICU collations against glibc 2.28 data corruption  08h00 09 juillet
Laurenz Albe 2019 As announced by the glibc mailing list and discussed by Daniel Vérité, version 2.28 of the GNU C library will ship with many changes to the collations. PostgreSQL uses the operating system’s collations by default. When this version hits your Linux operating system as...
14
Luca Ferrari: Generate Primary Keys (almost) Automatically  00h00 09 juillet
What if your database design is so poor that you need to refactor tables in order to add primary keys? Generate Primary Keys (almost) Automatically While playing on quite large database (in terms of number of tables) with a friend of mine, we discovered that almost all tables did not have a primary...
15
Luca Ferrari: PostgreSQL & recovery.conf  00h00 08 juillet
The coming version of PostgreSQL, 12, will loose the recovery.conf file. It will get some time to get used to PostgreSQL & recovery.conf According to the documentation for the upcoming version 12, the recovery.conf file has gone The release note states it clearly: the server will not start if...