Sammlung von Newsfeeds

Martin Davis: Querying Spatial Features with pg_featureserv

Neues vom PostgreSQL Planet - 11. März 2020 - 15:08

In addition to viewing PostGIS spatial data as vector tiles using pg_tileserv, it is often necessary to access data features directly. This supports use cases such as:

Laurenz Albe: Subtransactions and performance in PostgreSQL

Neues vom PostgreSQL Planet - 11. März 2020 - 9:30

© 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.

Pavlo Golub: Interview with Tomas Vondra

Neues vom PostgreSQL Planet - 10. März 2020 - 20:31

Tomas Vondra is a speaker of the PgDay Ukraine conference. He is working for 2ndQuadrant as a database engineer and developer, committer, …

Andreas 'ads' Scherbaum: Christophe Pettus

Neues vom PostgreSQL Planet - 9. März 2020 - 15:00
PostgreSQL Person of the Week Interview with Christophe Pettus: I’m a native Californian. My background is kind of random: I’ve been involved in electronic music, movies, writing comics, historical recreation, flying, and a lot of strange eCommerce companies. My first ‘real’ job was at the Jet Propulsion Laboratory, so I can legitimately claim to be a rocket scientist. Through a long, complicated set of events involving my happening to own a professional video camera, I’ve ended up as CEO of PostgreSQL Experts, Inc., a consultancy supporting PostgreSQL.

Bruce Momjian: Databases, Containers, and the Cloud

Neues vom PostgreSQL Planet - 7. März 2020 - 18:00

A few months ago, I wrote a high-level presentation about the deployment benefits of using containers and cloud infrastructure for databases. I am now ready to share this presentation. I have also added QR codes to the first and last slides of all my presentations, linking to my website.

Mark Wong: Creating a PostgreSQL procedural language – Part 4 – Handling Input Parameters

Neues vom PostgreSQL Planet - 6. März 2020 - 0:52
One method to handle input parameters with PL/Julia is to rewrite the body of the user defined function or stored procedure on the fly with the values declared as global variables. In order to do that, we need to create a new buffer big enough to hold the new global variable declarations in addition to […]

Ibrar Ahmed: Handling NULL Values in PostgreSQL

Neues vom PostgreSQL Planet - 5. März 2020 - 15:00
What is NULL?

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[1] and Two-valued logic known as bivalent[2]. 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.

Paul Ramsey: Crunchy Spatial: Tile Serving

Neues vom PostgreSQL Planet - 5. März 2020 - 11:47

Beautiful, responsive maps are best built using vector tiles, and PostgreSQL with PostGIS can produce vector tiles on-the-fly.

Hans-Juergen Schoenig: Reduce WAL by increasing checkpoint distance

Neues vom PostgreSQL Planet - 4. März 2020 - 9:00

If you are running PostgreSQL in production you might have already noticed that adjusting checkpoints can be a very beneficial thing to tune the server and to improve database performance overall. However, there is more to this: Increasing checkpoint distances can also help to actually reduce the amount of WAL that is created in the first place. That is right. It is not just a performance issue, but it also has an impact on the volume of log created.

You want to know why? Let us take a closer look!

Peter Eisentraut: Developing PostgreSQL for Windows, Part 2

Neues vom PostgreSQL Planet - 4. März 2020 - 8:15
In the previous blog post, we discussed the different Windows build variants that PostgreSQL supports. In this post, we’ll discuss how, as a Unix-based developer, you can check whether your patch might work on Windows. (For simplicity, I’ll say “Unix” to mean Linux, BSD, macOS, and similar.) First, there are a few ways to check […]

Ozgun Erdogan: Microsoft Azure and PostgreSQL—Committers, welcome aboard!

Neues vom PostgreSQL Planet - 3. März 2020 - 20:35

Interview with the Postgres committers who have joined the Postgres team at Microsoft by Sudhakar Sannakkayala (Partner Director, Azure Data) and Ozgun Erdogan (Principal, Azure Data)—cross-posted from the Azure Postgres blog.

pgCMH - Columbus, OH: Foreign Data Wrappers Accessing External Data from a PostgreSQL database

Neues vom PostgreSQL Planet - 3. März 2020 - 6:00

The March meeting will be held at 18:00 EST on Tues, the 24th. Once again, we will be holding the meeting in the community space at CoverMyMeds. Please RSVP on MeetUp so we have an idea on the amount of food needed.

Foreign data wrappers are part of Postgres’s implementation of the SQL/MED (Management of External Data) extension to the SQL standard, which provides the specs for accessing data that’s not actually in your database.

Marco Slot: Citus 9.2 speeds up large scale HTAP workloads on Postgres

Neues vom PostgreSQL Planet - 3. März 2020 - 0:50

Some of you have been asking, “what’s happening with the Citus open source extension to Postgres?” The short answer is: a lot. More and more users have adopted the Citus extension in order to scale out Postgres, to increase performance and enable growth.

Andreas 'ads' Scherbaum: Joe Conway

Neues vom PostgreSQL Planet - 2. März 2020 - 15:00
PostgreSQL Person of the Week Interview with Joe Conway: I grew up in New York, went to undergraduate university at Virginia Tech, and rode nuclear submarines for a few years. After that I married and spent many years in Southern California raising a family and working. A couple of years ago my wife and I moved to Florida to be closer to family. For the past 5 years I have been VP of Engineering at Crunchy Data.

Vik Fearing: pgDay Paris 2020 - Interview with Tomas Vondra

Neues vom PostgreSQL Planet - 2. März 2020 - 11:00

Read our interview with Tomas Vondra who will talk about CREATE STATISTICS - what is it about.

MMAP vs POSIX : PostgreSQL Dynamic Shared Memory

PostgresqlHelp - 2. März 2020 - 9:45

[postgres@stagdb pg_dynshmem]$ ls -lrt total 8 -rw------- 1 postgres postgres 6928 Feb 17 16:36 mmap.2106693104 [postgres@stagdb pg_dynshmem]$ pwd /u01/pgsql/10/pg_dynshmem

There is a file in pg_dynshmem sub-directory under PostgreSQL data directory.

  • But what is that file?

The answer is here,

Luca Ferrari: PostgreSQL 12 Generated Columns: another use case

Neues vom PostgreSQL Planet - 2. März 2020 - 1:00

When you start realizing how useful can be generated columns, you start using them as part of your workflow. Here there’s another story of mine in the adventures in PostgreSQL-land.

Stefan Fercot: pgBackRest auto-select backup

Neues vom PostgreSQL Planet - 2. März 2020 - 1:00

pgBackRest is a well-known powerful backup and restore tool.

The 2.24 version, released on February 25, introduced auto-selection of backup set on restore when time target is specified. Auto-selection is performed only when --set is not specified. If a backup set for the given target time can’t be found, the latest (default) backup set will be used.

Let’s illustrate it!

PostgreSQL and pgBackRest installation

Let’s install PostgreSQL and pgBackRest directly from the PGDG yum repositories: