Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 30 Minuten

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

Bruce Momjian: Storing Signatures in Databases

4. Juni 2021 - 18:15

I wrote a blog entry in 2018 about how to sign data rows so their authenticity can be verified by anyone using a public key. In talking to Chapman Flack, he mentioned that another option is to store data signatures in the database even if the data is stored outside the database. This allows the database to serve as a central location to verify the authenticity of externally-stored data.

Luca Ferrari: pgbackrest lands on FreeBSD!

3. Juni 2021 - 2:00

pgbackrest has been inserted into the FreeBSD ports!

Luca Ferrari: PostgreSQL Builtin Trigger Function to Speed Up Updates

3. Juni 2021 - 2:00

Did you know PostgreSQL ships with a pre-built trigger function that can speed up UPDATES?

Stefan Fercot: pgBackRest and SUSE

3. Juni 2021 - 2:00

I got the question the other day from a friend: “does pgBackRest work on SUSE?”. Having to admit I never really used SUSE, and not knowing what to answer, I decided to give it a try. Let’s see in this short post how far we can go.

Vagrant box

The openSUSE project provides several vagrant boxes including Leap 15.2:

Ibrar Ahmed: postgres_fdw Enhancement in PostgreSQL 14

2. Juni 2021 - 21:10

It’s exciting times in the PostgreSQL world with the version 14 beta released a few days ago. It’s now time to look under the hood and find out what has changed from version 13, see what has improved, and what behaviors are changed that we should be aware of. Putting it all in a single blog would take weeks to write and days to read, so this one will focus solely on the changes expected in the Foreign Data Wrapper in the GA release of PostgreSQL version 14.

Bruce Momjian: Pgsodium

2. Juni 2021 - 16:45

I created pg_cryptokey in 2019, which allows encryption key management at the SQL-level. A more sophisticated project is pgsodium, which uses libsodium for encryption and decryption.

Hans-Juergen Schoenig: Enabling and disabling autovacuum in PostgreSQL

2. Juni 2021 - 10:00

Autovacuum has been part of PostgreSQL for a long time. But how does it really work? Can you simply turn it on and off? People keep asking us these questions about enabling and disabling autovacuum a lot. PostgreSQL relies on MVCC to handle concurrency in a multiuser environment. The problem which arises when handling concurrent transactions is that dead tuples must be cleaned up.

Craig Kerstiens: Better JSON in Postgres with PostgreSQL 14

1. Juni 2021 - 20:17

Postgres has had "JSON" support for nearly 10 years now. I put JSON in quotes because well, 10 years ago when we announced JSON support we kinda cheated. We validated JSON was valid and then put it into a standard text field. Two years later in 2014 with Postgres 9.4 we got more proper JSON support with the JSONB datatype.