Sammlung von Newsfeeds
As for now, there are no strict official restrictions in Ukraine. However, the trend seems to be evident, and the COVID-19 epidemic will be in an active phase until June-July, 2020.
Taking this into account, we are postponing the conference. We’d like to kindly remind you, we’re not canceling the PGDay Ukraine 2020, it’s moved to Fall 2020. All purchased tickets are valid. You are still our participants and guests.
Hello there, this is your developer speaking…
PostgreSQL supports many secure ways to authenticate users, and one typical way is to use GSSAPI with Kerberos. However, when I was trying to investigate one issue which is related with GSSAPI in PostgreSQL, I couldn’t find a tutorial that I can follow to setup the environment easily. After some effort spent on Kerberos environment setup, I decided to write a blog to share what I have learned.
Since PostgreSQL GSSAPI user authentication does involve many background knowledge, I separate this blog into 3 parts:
The state of Baden-Württemberg declared that in order to control the rapidly changing COVID-19 situation, all events over 100 participants are banned for at least until mid of June 2020. This affects the German PostgreSQL Conference 2020, which was planned for May 15th in Stuttgart.
The changes in this new release are:
- missing archives output: the complete list is now only shown in --debug mode;
- new --list-archives argument to print the list of all the archived WAL segments found.
Let’s use the 1.7 release and see the basic output:
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.