Neues vom PostgreSQL Planet
When designing a database application, the layout of data in disk is often neglected. However, the way data is stored by PostgreSQL can have a major performance impact. Therefore it makes sense to take a look at what can be done to improve speed and throughput. In this post you will learn one of the most important tricks.PostgreSQL: To sort or not to sort
To demonstrate the importance of the on-disk layout I have created a simple test set:
Back in August 2019, I wrote multiple blogs with the title of “Horizontal scalability with Sharding in PostgreSQL – Where it is going Part 1 .. 3”. Little has happened since then, the purpose of this blog is discuss the important missing pieces of the puzzle, what are the minimum set of features needed to get to MVP (minimum viable product) and most importantly which efforts are currently going on to get to the MVP of Sharding in PostgreSQL core.
PostgreSQL 12 comes with a great new feature, Generated Columns. The functionality isn’t exactly anything new, but the standardization, ease of use, accessibility, and performance has been improved in this new version.
It is with heavy hearts that we have to announce that both Nordic PGDay 2020 (Helsinki, March 24th) and pgDay Paris 2020 (Paris, March 26th) have been canceled.
In light of the rapidly changing situation of the COVID-19 spread around Europe, and its effect on attendees, speakers, and sponsors ability and interest in safely attending, we feel at this point that this is the socially responsible thing to do.
There are no plans to postpone these events; we are instead focusing on returning next year, bigger and better than ever!
The organization team is closely following the recommendations of local, national, and international authorities. As of April 25, 2020 — in Ukraine — only assemblies of 200 people or more are restricted as well as events in contamination areas of which Lviv is not yet a part. However, the situation could change rapidly and we will update this page as needed. We also plan to keep attendees, speakers, and sponsors abreast of any significant changes.
© 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.