Sammlung von Newsfeeds
© Laurenz Albe 2020
Recently, while troubleshooting PostgreSQL performance problems, I ran into problems with subtransactions twice. So I thought this was a nice topic for another blog post.
Tomas Vondra is a speaker of the PgDay Ukraine conference. He is working for 2ndQuadrant as a database engineer and developer, committer, …
Read our interview with Daniel Westermann who will talk about [x],[y],zheap - What it is good for.
There is often some confusion about NULL value, as it is treated differently in different languages. So there is an obvious need to clarify what NULL is, how it works in different languages, and what the actual value is behind the NULL. Before going into details, there is also a need to understand the concept of Three-valued logic and Two-valued logic known as bivalent. The bivalent is a concept of boolean value where value can be true or false, but contrary to bivalent the Three-valued logic can be true, false, or (intermediate value) unknown.
If you are running PostgreSQL in production you might have already noticed that adjusting checkpoints can be a very beneficial thing to tune the server and to improve database performance overall. However, there is more to this: Increasing checkpoint distances can also help to actually reduce the amount of WAL that is created in the first place. That is right. It is not just a performance issue, but it also has an impact on the volume of log created.
You want to know why? Let us take a closer look!
Interview with the Postgres committers who have joined the Postgres team at Microsoft by Sudhakar Sannakkayala (Partner Director, Azure Data) and Ozgun Erdogan (Principal, Azure Data)—cross-posted from the Azure Postgres blog.
The March meeting will be held at 18:00 EST on Tues, the 24th. Once again, we will be holding the meeting in the community space at CoverMyMeds. Please RSVP on MeetUp so we have an idea on the amount of food needed.
Foreign data wrappers are part of Postgres’s implementation of the SQL/MED (Management of External Data) extension to the SQL standard, which provides the specs for accessing data that’s not actually in your database.
Some of you have been asking, “what’s happening with the Citus open source extension to Postgres?” The short answer is: a lot. More and more users have adopted the Citus extension in order to scale out Postgres, to increase performance and enable growth.
Read our interview with Tomas Vondra who will talk about CREATE STATISTICS - what is it about.
There is a file in pg_dynshmem sub-directory under PostgreSQL data directory.
- But what is that file?
The answer is here,
When you start realizing how useful can be generated columns, you start using them as part of your workflow. Here there’s another story of mine in the adventures in PostgreSQL-land.
pgBackRest is a well-known powerful backup and restore tool.
The 2.24 version, released on February 25, introduced auto-selection of backup set on restore when time target is specified. Auto-selection is performed only when --set is not specified. If a backup set for the given target time can’t be found, the latest (default) backup set will be used.
Let’s illustrate it!PostgreSQL and pgBackRest installation
Let’s install PostgreSQL and pgBackRest directly from the PGDG yum repositories: