Neues vom PostgreSQL Planet
Paul Ramsey: When Proj Grid-Shifts Disappear
Last week a user noted on the postgis-users list (paraphrase):
I upgraded from PostGIS 2.5 to 3.3 and now the results of my coordinate transforms are wrong. There is a vertical shift between the systems I’m using, but my vertical coordinates are unchanged.
PostGIS gets all its coordinate reprojection smarts from the proj library. The user’s query looked like this:
Amit Kapila: PostgreSQL 15 and beyond
PostgreSQL 15 builds upon the enhancements of earlier versions and takes them to the next level, with several improvements to logical replication, increased sorting performance, and the introduction of the MERGE command. I would like to talk about these features as well as what is under discussion for PostgreSQL 16.
Elizabeth Garrett Christensen: Intro to Postgres Custom Data Types
Custom data types is one of those many features that makes PostgreSQL flexible for development of a huge variety of business and application use cases. Data types will help you primarily for data integrity, ensuring your data is stored in the database as you want it to be. A common surprise gift of using strict data types is that you can end up reducing your long term data maintenance.
There’s two main ways to customize data types in Postgres:
Ibrar Ahmed: Unlocking the Secrets of TOAST: How To Optimize Large Column Storage in PostgreSQL for Top Performance and Scalability
PostgreSQL is a fantastic database, but if you’re storing images, video, audio files, or other large data objects, you need to “toast” them to get optimal performance. This post will look at using The Oversized-Attribute Storage Technique (TOAST) to improve performance and scalability.
Akhil Reddy Banappagari: Null and Empty string in Oracle vs PostgreSQL vs SQL Server
Database migrations from Oracle to PostgreSQL and SQL Server to PostgreSQL can get tricky when certain differences are not known. Unknown differences can lead to migration failures.
Lætitia AVROT: is it a bug?
Henrietta Dombrovskaya: PG Day Chicago Registration Is Open!
Register at the conference website, and take advantage of the Early Bird discount!
Laurenz Albe: Transaction ID wraparound: a walk on the wild side
© Laurenz Albe 2022
Andreas 'ads' Scherbaum: Luca Ferrari
Christophe Pettus: Nordic PgDay 2023
I’m very pleased to be talking about real-life logical replication at Nordic PgDay 2023, in beautiful Stockholm.
Peter Eisentraut: PostgreSQL supply chain
If you are an application developer and you build on PostgreSQL, then maybe you have looked into where PostgreSQL comes from, who develops it, and where you can get professional help if needed.
Now, if you are a PostgreSQL developer (hi!), do you know what you are building on, where those things come from, who develops them, and where you get get professional help if needed?
Consider the dependency diagram of the internet:
Andreas Scherbaum: Relational and Non-relational Data: PGSQL Phriday #005
Ryan Lambert asks in this month's PGSQL Phriday:
Magnus Hagander: PGDay/MED 2023 - Call for Papers
PGDay/MED is pleased to announce that the call for papers is open for our inaugural conference.
We are looking for talks on any PostgreSQL-related subject for the one-day conference. Got a big idea you want to share? A problem you have an innovative solution to? An advancement you want to put forward? We want to hear from you!
All talks should last about 40-45 minutes, with an additional 5-10 minutes for questions. Due to the international nature of our audience, we are requesting that talks be made in English for this conference.
David Z: Large Object in PostgreSQL
Sometimes, you may need to manage large objects, i.e. CLOB, BLOB and BFILE, using PostgreSQL. There are two ways to deal with large objects in PostgreSQL: one is to use existing data type, i.e. bytea for binary large object, and text for character-based large object; another is to use pg_largeobject; This blog will explain how to use pg_largeobject.
Ryan Booz: PGSQL Phriday #005
Invitation from Ryan Lambert
Chris Travers: How TimescaleDB Solves Common PostgreSQL Problems in Database Operations With Data Retention Management
In my career, I have frequently worked for companies with large amounts of time-partitioned data, where I was a software engineer focusing on our PostgreSQL databases. So it was my job to deal with outages in the database. One source of repeated outages has been partition management to handle data retention.
Jagadeesh Panuganti: Migration of Synonyms from Oracle to PostgreSQL
You might have already seen our previous articles supporting Oracle to PostgreSQL and SQL server to PostgreSQL migrations. Our previous articles have provided solutions to some of the complexities during Oracle to PostgreSQL migrations. In this article, we are going to discuss about migration of synonyms from Oracle to PostgreSQL.
Robert Haas: Surviving Without A Superuser - Coming to v16
Jobin Augustine: WAL Compression in PostgreSQL and Recent Improvements in Version 15
Attempts to compress PostgreSQL WAL at different levels have always been around since the beginning. Some of the built-in features (wal_compression) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. But it is time to take another look at the built-in wal_compression because PostgreSQL 15 has much more to offer.
Greg Sabino Mullane: How to Solve Advent of Code 2022 Using Postgres - Day 14
This article will contain spoilers both on how I solved 2022 Day 14's challenge "Regolith Reservoir" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language. This article is delayed from the actual puzzle's release. Also note that my solutions are seldom going to be the "best" solutions - they were solved as quickly as possible, and these articles will show my first solutions, with some minor reformatting and cleaning up.