Sammlung von Newsfeeds
I would like to start the blog with an interesting fact: the language PL/pgSQL, which is used to build procedural code logic in PostgreSQL, is also an extension that is installed by default when you create a database.
PostgreSQL is designed to be extensible, allowing us to load extensions that introduce additional features to functions as if they were built-in.
The Postgres playground started with a fun idea of "I wonder if I can put Postgres in a web browser". It evolved to a full set of guided tutorials that you can follow along step by step with. We actually use Notion to power all of our tutorials and an in-house API. This means a new tutorial is as simple as some SQL and some markdown. But, did you know you can bring your own setup to the playground?
Among the many connection parameters that PostgreSQL supports, there’s a set of SSL-related settings (with the “ssl*” prefix) in which “sslmode” sets the negotiation priority with the server through six modes.
Preparing the keynote for FOSS4G North America this year felt particularly difficult. I certainly sweated over it.
Please join us in Chicago on April 26, 2024, for the 2nd PG Day Chicago! See details on the conference website. This time, the venue will be in the Loop (311 W. Monroe Street), which should be more convenient for both local participants and out-of-town visitors.
The Call for papers is open, as well as the Call for sponsors, and as always, we are looking for volunteers! Please visit our website for all of the information, and please consider submitting, sponsoring, and coming :).
Deploying PostgreSQL on Kubernetes is not new and can be easily streamlined through various Operators, including Percona’s. There are a wealth of options on how you can approach storage configuration in Percona Operator for PostgreSQL, and in this blog post, we review various storage strategies — from basics to more sophisticated use cases.
In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, we learned what an index is, and how exactly indexes can help with query execution. But there is much more to learn about indexes! In this blog, we will keep exploring B-tree indexes.
An introduction to database generated columns, using PostgGIS, GeoDjango and the new GeneratedField added in Django 5.0.
It was my absolute pleasure to speak at Helvetic Ruby in Bern, Switzerland on 24 November 2023. It was a day of firsts:
- my first interaction with the Ruby community
- the first conference organised by this team
- the first Ruby conference in Switzerland
I enjoyed the whole experience so much that I want to tell you all about it and encourage you to add the 2024 edition to your calendar as soon as the date's announced.
PostGIS Day 2023 videos came out recently. PostGIS Day conference is always my favorite conference of the year because you get to see what people are doing all over the world, and it always has many many new tricks for using PostgreSQL and PostGIS family of extensions you had never thought of. Most importantly it's virtual, which makes it much easier for people to fit in their schedules than an on site conference. We really need more virtual conferences in the PostgreSQL community.
An example of how to run the Docker images provided by the Github repository.
Database monitoring, performance tuning and query optimization are critical operations for maintaining an efficient database system. A key component in PostgreSQL for this purpose is the pg_stat_all_tables view. pg_stat_all_tables offers real time statistics on table activities such as number of sequential and index scans performed on a table, updates, deletes, inserts, and more. It also […]