Sammlung von Newsfeeds

David Z: Free Space Mapping file in details

Neues vom PostgreSQL Planet - vor 1 Stunde 2 Minuten
1. Overview

Previously, we discussed the MAIN fork file and corresponding extension at Heap file and page in details. This blog will explain a little bit more about the Free Space Mapping file and corresponding extension.

Steven Pousty: Using PostgreSQL to Shape and Prepare Scientific Data

Neues vom PostgreSQL Planet - 22. Oktober 2020 - 16:04

Today we are going to walk through some of the preliminary data shaping steps in data science using SQL in Postgres. I have a long history of working in data science, including my Masters Degree (in Forestry) and Ph.D.

Tomas Vondra: TPC-H performance since PostgreSQL 8.3

Neues vom PostgreSQL Planet - 22. Oktober 2020 - 11:15
In the first part of this blog series, I’ve presented a couple of benchmark results showing how PostgreSQL OLTP performance changed since 8.3, released in 2008. In this part I plan to do the same thing but for analytical / BI queries, processing large amounts of data. There’s a number of industry benchmarks for testing […]

James Chanco: Logical Replication Upgrade in Postgres

Neues vom PostgreSQL Planet - 20. Oktober 2020 - 19:49

In our previous blog post, we talked about upgrading a PostgreSQL cluster to a new major version with pg_upgrade. This can be fast and with little downtime even for large databases, but in some instances zero downtime may be essential for doing a major upgrade.

Ian Barwick: pg_rewind changes in PostgreSQL 13

Neues vom PostgreSQL Planet - 20. Oktober 2020 - 19:31

There have been a lot of articles about new features in the recent PostgreSQL 13 release, but one set of improvements which seems to have escaped much attention is in pg_rewind , which has gained some additional useful functionality deserving of closer examination.

Hans-Juergen Schoenig: zheap: Inspecting storage sizes

Neues vom PostgreSQL Planet - 20. Oktober 2020 - 9:30

To dig a bit deeper into zheap and PostgreSQL storage technology in general I decided to provide some more empirical information about space consumption. As stated in my previous blog post about zheap is more efficient in terms of storage consumption. The reasons are:

movead li: The way PG store null value in record

Neues vom PostgreSQL Planet - 20. Oktober 2020 - 3:46

When inserting data into a table, you can specify that the value of a field is null. For example, for a table t (i int, j int, k int), we can execute insert into t values (8,1,6), or insert into t values (3, null, 7) to insert a record with a null value. This blog will explore some technical details of storing null values in PostgreSQL.

Andreas 'ads' Scherbaum: Damien Clochard

Neues vom PostgreSQL Planet - 19. Oktober 2020 - 16:00
PostgreSQL Person of the Week Interview with Damien Clochard: I’m Damien Clochard, I live in France and I’m the president of PostgreSQLFr, the French Speaking PostgreSQL association. I’m also one of the founder of Dalibo, a French PostgreSQL company and one the sysadmins behind the platform.

Michał Mackiewicz: Data consistency issues in logical replication

Neues vom PostgreSQL Planet - 19. Oktober 2020 - 12:28

In contrast to physical (streaming) replication, write access on subscriber node is not disabled. This means that DML and DDL statements like INSERT, UPDATE, DELETE or ALTER can be executed on subscriber. As the replication is unidirectional, however, these changes won’t be replicated back to publisher. This behavior can lead to problems – the replication can stop with all its consequences or the data can become out of sync.

Ryan Lambert: Postgres 13 Performance with OpenStreetMap data

Neues vom PostgreSQL Planet - 19. Oktober 2020 - 7:01

With Postgres 13 released recently, a new season of testing has begun! I recently wrote about the impact of BTree index deduplication, finding that improvement is a serious win. This post continues looking at Postgres 13 by examining performance through a few steps of an OpenStreetMap data (PostGIS) workflow.

Hans-Juergen Schoenig: PostgreSQL: Sophisticating temporary tables

Neues vom PostgreSQL Planet - 16. Oktober 2020 - 10:00

Temporary tables have been around forever and are widely used by application developers. However, there is more to temporary tables than meets the eye. PostgreSQL allows you to configure the lifespan of a temporary table in a nice way and helps to avoid some common pitfalls.


By default, a temporary table will live as long as your database connection. It will be dropped as soon as you disconnect. In many cases this is the behavior people want:

Scott Mead: Tracking Postgres Stats

Neues vom PostgreSQL Planet - 15. Oktober 2020 - 22:12

Database applications are living, [(sometimes) fire-]breathing systems that behave in unexpected ways. As a purveyor of the pgCraft, it’s important to understand how to interrogate a Postgres instance and learn about the workload. This is critical for lots of reasons:

Alexey Lesovsky: Postgres 13 Observability Updates

Neues vom PostgreSQL Planet - 15. Oktober 2020 - 19:38

New shiny Postgres 13 has been released and now it’s the  time for making some updates to “Postgres Observability” diagram.

New release includes many improvements related to monitoring, such as new stats views and new added fields to existing views. Let’s take a closer look at these.

Tom Swartz: Tuning Your Postgres Database for High Write Loads

Neues vom PostgreSQL Planet - 14. Oktober 2020 - 18:47

As a database grows and scales up from a proof of concept to a full-fledged production instance, there are always a variety of growing pains that database administrators and systems administrators will run into.

Bruce Momjian: Thirty Years of Continuous PostgreSQL Development

Neues vom PostgreSQL Planet - 14. Oktober 2020 - 18:30

I did an interview with EDB recently, and a blog post based on that interview was published yesterday. It covers the Postgres 13 feature set and the effects of open source on the software development process.

Hans-Juergen Schoenig: pg_squeeze: Optimizing PostgreSQL storage

Neues vom PostgreSQL Planet - 14. Oktober 2020 - 9:00

Is your database growing at a rapid rate? Does your database system slow down all the time? And maybe you have trouble understanding why this happens? Maybe it is time to take a look at pg_squeeze and fix your database once and for all. pg_squeeze has been designed to shrink your database tables without downtime. No more need for VACUUM FULL – pg_squeeze has it all.

rob sullivan: Using pg_repack in AWS RDS

Neues vom PostgreSQL Planet - 13. Oktober 2020 - 2:00

As your database keeps growing, there is a good chance you're going to have to address database bloat.
While Postgres 13 has launched with some exciting features with built-in methods to rebuild indexes concurrently, many people still end up having to use pg_repack to do an online rebuild of the tables to remove the bloat. Customers on AWS RDS struggle figuring out how to do this. Ready to learn how?

Andreas 'ads' Scherbaum: Greg Sabino Mullane

Neues vom PostgreSQL Planet - 12. Oktober 2020 - 16:00
PostgreSQL Person of the Week Interview with Greg Sabino Mullane: My name is Greg Sabino Mullane, and I live in Pennsylvania (USA). I have been working remotely a long time - since before it became necessary this year - as a programmer and a DBA (database administrator).

Paul Ramsey: Talking PostGIS on Podcasts

Neues vom PostgreSQL Planet - 12. Oktober 2020 - 10:00

Here in the Covid-times, I haven’t been able to keep up my previous schedule of speaking at conferences, but I have managed to participate in a couple of episodes of the MapScaping Podcast, hosted by Daniel O’Donohue.