Planet PostgreSQL
1
Laurenz Albe: Never lose a PostgreSQL transaction with pg receivewal  11h30 22 octobre
Laurenz Albe 2019 Durability , the D of ACID, demands that a committed database transaction remains committed, no matter what. For normal outages like a power failure, this is guaranteed by the transaction log (WAL). However, if we want to guarantee durability even in the face of more...
2
Vik Fearing: pgDay Paris 2020 - Call for Papers Open  08h00 22 octobre
The call for papers for pgDay Paris 2020 is now open. Submit your proposals for interesting talks about all things PostgreSQL, and join us in March https: 2020.pgday.paris callforpapers
3
Pavel Stehule: dll for plpgsql check 1.7 are available for PostgreSQL 10, 11, and 12  21h10 20 octobre
I prepared dll libraries. You can load it from url plpgsql check-1.7.6-x64-win.zip.InstallationDownload, unzip and choose related dll filerename to plpgsql check.dll and copy to PostgreSQL’s lib directory (Program Files PostgreSQL 10 lib)copy plpgsql check-1.7.sql and plpgsql check.control to...
4
Pavel Stehule: precompiled libraries for orafce 3.8 for PostgreSQL 10, 11 and 12  09h55 20 octobre
I upload precompiled libraries to postgres.cz files orafce-3.8.0-x64.zip. These libraries are 64bit only (there is not 32bit build for Postgres 11 and 12). For 32bit or older PostgreSQL releases, please, use older orafce builds. Windows build is partially reduced - there are not support for PLVlex...
5
Regina Obe: PostGIS 3.0.0  00h00 20 octobre
The PostGIS development team is pleased to release PostGIS 3.0.0. This release works with PostgreSQL 9.5-12 and GEOS 3.6. If you are using postgis sfcgal extension, you need to compile against SFCGAL 1.3.1 or higher. Best served with PostgreSQL 12 , GEOS 3.8.0 and pgRouting 3.0.0-beta. ...
6
Magnus Hagander: Nordic PGDay 2020 - Call for Papers open  15h15 18 octobre
The call for papers for Nordic PGDay 2020 in Helsinki, Finland, is now open. Submit your proposals for interesting talks about all things PostgreSQL, and join us in March. Just like two years ago, the conference is held in cooperation with pgDay.paris which is held two days later. So if you are...
7
Alex Korban: Generating land-constrained geographical point grids with PostGIS  00h00 17 octobre
When I was in the market for an EV, one of the things I wondered about was how far I would be able to go outside the city before I had to charge it. Having a number for the range isn’t enough to know offhand whether I’d be able to reach a particular destination. So I wanted to make the range more...
8
Regina Obe: PostGIS 3.0.0 coming soon - Try 3.0.0rc2 at a package repo near you  23h15 15 octobre
PostGIS 3.0.0 is planned for release early next week. In the meantime you will find PostGIS 3.0.0rc1 or rc2 available via yum.postgresql.org, apt.postgresql.org, and EDB Windows 64-bit stackbuilder for PostgreSQL 12. Continue reading PostGIS 3.0.0 coming soon - Try 3.0.0rc2 at a package repo...
9
Vasilis Ventirozos: Tuning checkpoints  21h52 15 octobre
We recently had the chance to help a customer with some IO related issues that ended up being unconfigured checkpoints. Something that may not always be obvious but can actually be somewhat common.Let’s start with how things roughly work.Postgres smallest IO unit is a disk block that is 8kb (by...
10
Hans-Juergen Schoenig: Prewarming PostgreSQL I O caches  08h00 15 octobre
PostgreSQL uses shared buffers to cache blocks in memory. The idea is to reduce disk I O and to speed up the database in the most efficient way possible. During normal operations your database cache will be pretty useful and ensure good response times. However, what happens if your database...
11
à lvaro Herrera: Managing another PostgreSQL Commitfest  05h28 15 octobre
I have written about managing a PostgreSQL commitfest before. During the PostgreSQL 13 development cycle, I did it again. This time I used a different strategy, mostly because I felt that there was excessive accumulation of very old patches that had received insufficient attention. So apart from...
12
Federico Campoli: Regenerated  00h00 15 octobre
With PostgreSQL 12 the generated columns are now supported natively. Until the version Postgresql 11 it were possible to have generated columns using a trigger. In this post we’ll see how to configure a generated column via trigger and natively then we’ll compare the performances of both...
13
Euler Taveira de Oliveira: Postgres Object ownership  22h26 14 octobre
Sometimes I have to fix some object ownership such as tables and views. Let’s figure out if there is such object in your database:---- list tables, views, foreign tables and sequences not owned by role postgres--SELECT n.nspname AS SCHEMA, c.relname AS relation, pg get userbyid(c...
14
Robert Haas: Braces Are Too Expensive  18h39 14 octobre
PostgreSQL has what’s sometimes called a Volcano-style executor, after a system called Volcano, about which Goetz Greafe published several very interesting papers in the early to mid 1990s. PostgreSQL was in its infancy in those days, but many of the concepts in the Volcano papers have made their...
15
à lvaro Herrera: PostgreSQL 12: Foreign Keys and Partitioned Tables  07h55 14 octobre
Now that PostgreSQL 12 is out, we consider foreign keys to be fully compatible with partitioned tables. You can have a partitioned table on either side of a foreign key constraint, and everything will work correctly. Why do I point this out? Two reasons: first, when partitioned tables were first...