Neues vom PostgreSQL Planet

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

Weaponry Weaponry: pgSCV 0.6.0 released.

11. Juni 2021 - 6:34

New pgSCV 0.6.0 has been released, with two new features and with minor fixes and improvements.

pgSCV is a Prometheus exporter and monitoring agent for PostgreSQL environment. Project’s goal is to provide a single tool (exporter) for collecting metrics about PostgreSQL and related services.

Jędrzej Biedrzycki: Ignore nulls in Postgres

11. Juni 2021 - 5:55
0. Problem statement

One of the most missing features in Postgres in my opinion was always a possibility to ignore nulls in analytic functions. Other databases support ignore nulls clause which makes the task much easier. Let’s start by creating a simple, two-column table and populating it with data:

create table tbl ( id bigint primary key, a int ); insert into tbl (id, a) select s, case when random() < .5 then s end from generate_series(0, 100) s;

The problem is to generate a column (lnn – last not null) with the last non-null value ordered by id:

Luca Ferrari: Using ora2pg to do a kind of backup

11. Juni 2021 - 2:00

How I implemented a kind of Oracle-to-PostgreSQL backup.

Hans-Juergen Schoenig: Data warehousing: Making use of synchronized seq scans

10. Juni 2021 - 11:00

PostgreSQL contains some hidden gems which have been around for many years and help to silently speed up your queries. They optimize your SQL statements in a clever and totally transparent way. One of those hidden gems is the ability to synchronize sequential scans. Actually, this feature has been around for 15+ years, but has gone mostly unnoticed by many end-users. However, if you are running data warehouses and analytical workloads, you might have already used synchronized seq scans without actually knowing it.

Joshua Drake: What makes a Postgres contributor?

9. Juni 2021 - 21:39

In many Open Source communities it is difficult to consider who a contributor is. Some projects take an exclusive view, requiring a direct contribution to be made to be considered a contributor. Looking at this holistically, we find that the success of a project is found only when there is a mutual connection between the hands-on team and those who support it.Without that connection, PostgreSQL would just be a fever dream of academic pursuit.

Bruce Momjian: Looking Back at Postgres

9. Juni 2021 - 20:30

Postgres history goes back 35 years, and it is always interesting for me to hear details about the early years and the project decisions that were made. Fortunately, Joseph M.

Jonathan Katz: Better Range Types in Postgres 14: Turning 200 Lines of SQL Into 3

9. Juni 2021 - 20:00

I can talk about the benefits of PostgreSQL for application development and operations all day.

Vik Fearing: Benchmarking PostgreSQL: Improving Performance Stability

9. Juni 2021 - 19:45
Continuing my monthly PostgreSQL benchmarks series, these latest findings are aimed at helping developers improve PostgreSQL performance stability. I discovered the performance stability issue when I had to reset the AWS instance I used for the Daily 500 benchmarks and lost 20% performance. The only explanation I have is that the reset instance physically moved in the data center. From an ongoing benchmarking perspective, this is unacceptable. [Continue reading...]

Robert Treat: Where To Get Postgres Help Online?

9. Juni 2021 - 15:06

In the recent Postgres Community Survey by Timescale, nearly 50% of users reported that they started using Postgres within the last 5 years, including almost 20% within just the last 2 years. With the pandemic and subsequent lock-downs wiping out so many local user groups and in-person conferences, being able to get help and network with other Postgres users online has never been more important.

Laurenz Albe: Disabling autocommit in PostgreSQL can damage your health

9. Juni 2021 - 11:00

© Laurenz Albe 2021

When analyzing customer’s problems, I have seen the mess you can get into if you disable autocommit in your interactive client, so I’d like to bring this topic to a wider audience.

What is autocommit?

In PostgreSQL, like in any other ACID-complicant database, each statement runs in a transaction: if the statement causes an error, PostgreSQL undoes all its effects.

Hubert 'depesz' Lubaczewski: Many changes on

9. Juni 2021 - 0:27
Some time ago Eugen Konkov mailed me that he'd like to have some changes on One of the changes was actual bug, but the rest were improvements to functionality. I kinda didn't want to do it, but when I looked closer it appeared to me that there are some subtle bugs, and when I'll … Continue reading "Many changes on"

Dimitri Fontaine: PostgreSQL as a Microservice

8. Juni 2021 - 13:40
The MACI French podcast honoured me with an invitation to a guest appearance on their weekly schedule. As you can imagine, we talked about many things related to PostgreSQL… and also reacted to some newsworthy articles carefully curated by the MACI team. One of the topics we discussed in the podcast started with looking at PostgreSQL through the angle of it being one of the microservices that your application would be composed of.

Luca Ferrari: Template Databases

8. Juni 2021 - 2:00

PostgreSQL relies on the concept of template databases to create a new one.

Bruce Momjian: Time Zone Abbreviations

7. Juni 2021 - 20:30

Postgres is a convenient platform to manage and manipulate date and timestamp information, and included in that is the ability to manage time zones. Postgres can be compiled to use pre-installed time zone definitions, or --with-system-tzdata can be used to specify an external time zone definition directory.

David Christensen: Devious SQL: Run the Same Query Against Tables With Differing Columns

7. Juni 2021 - 19:12

We spend time day in, day out, answering the questions that matter and coming up with solutions that make the most sense. However, sometimes a question comes up that is just so darn…interesting that even if there are sensible solutions or workarounds, it still seems like a challenge just to take the request literally. Thus was born this blog series, Devious SQL.

Andreas 'ads' Scherbaum: Tom Kincaid

7. Juni 2021 - 16:00
PostgreSQL Person of the Week Interview with Tom Kincaid: I live outside Boston MA. I was born here and spent the majority of my life around here.

Weaponry Weaponry: Grafana dashboards for pgSCV.

7. Juni 2021 - 11:12

A week ago I announced pgSCV — a new metrics exporter for PostgreSQL. After that, some people asked me about dashboards — it will be nice to provide dashboards for pgSCV. I had a task to make dashboards in my todo list, and the request for dashboards didn’t surprise me.

Michael Paquier: Postgres 14 highlight - Memory dumps

6. Juni 2021 - 8:42

PostgreSQL has gained two features that help in getting information about the memory usage of sessions. First, as of this commit, there is one new system view that reports the memory usage for a session:

Andrew Dunstan: Buildfarm adopts modern git naming

5. Juni 2021 - 18:01

In keeping with modern git practice, I have renamed the default branch on both the client-code and server-code repositories to main. If you have a clone of either of these repositories, you can adapt to the change by doing the following commands in your local repo:

Ryan Lambert: Use BIGINT in Postgres

5. Juni 2021 - 7:01

This post examines at a common database design decision involving the choice of using BIGINT versus INT data types. You may already know that the BIGINT data type uses twice the storage on disk (8 bytes per value) compared to the INT data type (4 bytes per value). Knowing this, a common decision is to use INT wherever possible, only resorting to using BIGINT when it was obvious* that the column will be storing values greater than 2.147 Billion (the max of INT).