Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 3 Minuten

Christophe Pettus: PgDaySF 2020!

13. November 2019 - 21:26

The very first PgDay San Francisco is coming to the Swedish-American Hall on January 21, 2020. It’s going to be an amazing event.

If you have something to say about PostgreSQL…

… the Call for Proposals is now open through November 22, 2019. We are looking for 40 minute talks about anything related to PostgreSQL. First-time speakers are particularly encouraged to send in proposals.

Craig Kerstiens: An interview on what makes Postgres unique (extensions)

13. November 2019 - 15:00

I’ve been at dinners before with developers that admitted developers, themselves included, can be a bit opinionated. In one case one said for example, “I love Postgres, but I have no idea why.” They were sitting at the wrong table to use Postgres as an example… But it is quite often that I am asked Why Postgres.

Vik Fearing: pgDay Paris 2020 - Call for Sponsors Open

13. November 2019 - 10:00

The call for sponsors for pgDay Paris 2020 is now open. There are two levels available: Partner and Supporter. The Partner level, which gives you a booth at the event, is limited to just five spots so hurry up and get yours now before it's too late!

Paul Ramsey: ST_Subdivide all the Things

13. November 2019 - 9:00

This post originally appeared in the CARTO blog.

One of the things that makes managing geospatial data challenging is the huge variety of scales that geospatial data covers: areas as large as a continent or as small as a man-hole cover.

The data in the database also covers a wide range, from single points, to polygons described with thousands of vertices. And size matters! A large object takes more time to retrieve from storage, and more time to run calculations on.

Hubert 'depesz' Lubaczewski: More functions for json/yaml/xml plans on

13. November 2019 - 6:15
Added two new functions, which basically work only for JSON / YAML / XML plans. First – the view of source explain is now syntax highlighted. Just click source button on one of these to see: JSON YAML XML Next additon is text tab, which shows the same explain but converted to text-format. Hope you'll … Continue reading "More functions for json/yaml/xml plans on"

Hubert 'depesz' Lubaczewski: New Pg::Explain and

12. November 2019 - 23:41
Just now pushed new version of Pg::Explain Perl library that is handling parsing for There have been many changes, but the short summary is: Fix display of heap fetches from json ( Move global data (planning/execution/total time, trigger info) from top_node to explain object itself Add method to easily get real total, wall-clock, runtime … Continue reading "New Pg::Explain and"

Dimitri Fontaine: List PostgreSQL tables using extensions

12. November 2019 - 18:30

Postgres has extensions, and that’s awesome! Of course as the author of CREATE EXTENSION I’m a little biased… just remember that the ability to extend Postgres is way more than just this command. The whole database system has been design from the ground up to allow for extensibility. Parts of the design is to be found in the way you can register new objects at runtime: functions of course, and also data types, operators, index support structures such as operator classes and families, even index access methods!

Luca Ferrari: PostgreSQL ascii logo for FreeBSD boot loader

12. November 2019 - 1:00

I spent some time making an elephant logo to be used as FreeBSD boot loader logo.

Colin Charles: Database Tab Sweep

10. November 2019 - 15:22

I miss a proper database related newsletter for busy people. There’s so much happening in the space, from tech, to licensing, and even usage. Anyway, quick tab sweep.

Jobin Augustine: Configure HAProxy with PostgreSQL Using Built-in pgsql-check

8. November 2019 - 15:35

We discussed one of the traditional ways to configure HAProxy with PostgreSQL in our previous blog about HAProxy using Xinetd. There we briefly mentioned the limitation of the HAProxy’s built-in pgsql-check health check option. It lacks features to detect and differentiate the Primary and Hot-Standby.

cary huang: Replication Failover with pg_rewind in PG12

7. November 2019 - 23:15
1. Overview

In the previous blog, we have discussed how to correctly set up streaming replication clusters between one master and one slave in Postgres version 12. In this blog, we will simulate a failover scenario on the master database, which causes the replica (or slave) database cluster to be promoted as new master and continue the operation. We will also simulate a failback scenario to reuse the old master cluster after the failover scenario with the help of pg_rewind.

cary huang: Streaming Replication Setup in PG12 – How to Do it Right

7. November 2019 - 23:11
1. Overview

PostgreSQL 12 has been considered as a major update consisting of major performance boost with partitioning enhancements, indexing improvements, optimized planner logics and several others. One of the major changes is noticeably the removal of recovery.conf in a standby cluster. For this reason, the procedure to set up a streaming replication clusters has changed, and in this blog, I will demonstrate how to properly setup a streaming replication setup in PG12.

damien clochard: Achieving k-anonymity with PostgreSQL

7. November 2019 - 12:17

Dalibo Labs just released yesterday the version 0.5 of PostgreSQL Anonymizer, an extension that hides sensitive information inside a PostgreSQL database.

Abdul Yadi: pgAdmin3 for PostgreSQL 12.0

7. November 2019 - 5:27

Why do I still need pgAdmin3? As of now, pgAdmin4 does not show nested partition table in its object tree view. Since pgAdmin3 LTS repository in bitbucket by BigSQL Development Team is no longer available, I republish it in github: with code fixes for PostgreSQL 12 internal relation field changes:

Richard Yen: Making Mystery-Solving Easier with auto_explain

6. November 2019 - 22:00

I recently had to work on a case where a customer noticed some poor application performance after migrating from Oracle to PostgreSQL. They seemed to have tried everything in the playbook, but the problem simply wouldn’t get any better.

Dimitri Fontaine: PostgreSQL Query Plan Visualizer

6. November 2019 - 20:45
Photo by unsplash-logoHanna Morris Postgres Query Planning PostgreSQL provides advanced tooling to understand how it executes SQL queries. The execution of a query follows specific steps: Parsing Planning Optimization Execution When it comes to the execution step, all Postgres does is follow the selected optimized plan. It is possible to ask Postgres for the query plan and inspect it, in order to better understand the execution of any query and then when necessary find a way to execute the same query faster.

Paul Ramsey: GZip in PostgreSQL

6. November 2019 - 9:00

I love PostgreSQL extensions.

Extensions are the truest expression of the second principle of the original “design of Postgres” vision, to

provide user extendibility for data types, operators and access methods.

Kirk Roybal: PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes

5. November 2019 - 17:57
K-nearest neighbor answers the question of "What is the closest match?". PostgreSQL 12 can answer this question, and use indexes while doing it.

Luca Ferrari: PostgreSQL 12 Generated Columns

4. November 2019 - 1:00
Unable to clean HTML