Neues vom PostgreSQL Planet
After 20 years in professional PostgreSQL support and consulting we are finally able to answer one of the most frequently asked questions: “How can I see all active query plans?” Ladies and gentlemen, let me introduce you to pg_show_plans, an extension which does exactly that. pg_show_plans is Open Source and can be used free of charge as a standard PostgreSQL extension.
In previous blog, we have setup Kerberos, added all required principals and verified each principal. This blog will explain all the necessary configuration, i.e. postgresql.conf, pg_hba.conf and pg_ident.conf, in PostgreSQL for user authentication using GSSAPI with Kerberos.
This is my first blog in a series of SQL optimization blogs. So expect some basic information in here along with some nice insights. My aim is to help you walk through a complete process of understanding and optimizing queries for improved performance. A PostgreSQL server attempts to find the most effective way of building a result set for the query. The first step in that direction is the ability to understand what the “EXPLAIN” command is.
Fernando Laudares Camargos: A Tale About Migrating a PostgreSQL Database Between Different DBaaS Providers
We recently helped migrate a production PostgreSQL database running on a given DBaaS platform… to another DBaaS platform. When it comes to vendor “lock-in”, some providers are easier (and even friendlier) to deal with than others, but it is never a straightforward process.
© Laurenz Albe 2020
Embedded SQL is by no means a new feature — in fact it is so old-fashioned that many people may not know about it at all. Still, it has lots of advantages for client code written in C. So I’d like to give a brief introduction and talk about its benefits and problems.
PostgreSQL and MongoDB are two popular open source relational (SQL) and non-relational (NoSQL) databases available today. Both are maintained by groups of very experienced development teams globally and are widely used in many popular industries for adminitration and analytical purposes. MongoDB is a NoSQL Document-oriented Database which stores the data in form of key-value pairs expressed in JSON or BSON; it provides high performance and scalability along with data modelling and data management of huge sets of data in an enterprise application.
There is a lot of interest and discussions lately in the PostgreSQL world to make it a scale-out solution. Among other possible solutions, one of the most promising ones is to implement the sharding using FDW and table partitioning for distributing the data on multiple servers. As of now, PostgreSQL can only fetch the data from FDW in serial and that is one thing that needs to be improved to increase the performance.
Users had often asked where they could find older versions of packages from apt.postgresql.org. I had been collecting these since about April 2013, and in July 2016, I made the packages available via an ad-hoc URL on the repository master host, called "the morgue". There was little repository structure, all files belonging to a source package were stuffed into a single directory, no matter what distribution they belonged to.
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: