A unique constraint where NULL conflicts with everything
by
Laurenz Albe |
01.2023 I have been faced with a request for an unusual unique constraint that puzzled me for a while. Since […]
UNION ALL, data types and performance
by
Laurenz Albe |
12.2022 A while ago, I wrote about the performance impact of query parameter data types. Recently I encountered a similar […]
ERROR: nextval: reached maximum value of sequence
Fix "ERROR: nextval: reached maximum value of sequence in PostgreSQL" - related to using serial data type to generate auto-increment columns
Next to character encoding, time zones are among the least-loved topics in computing. In addition, PostgreSQL's implementation of timestamp […]
Multiranges in PostgreSQL 14
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.
Query parameter data types and performance
by
Laurenz Albe |
03.2022 Recently, I could help solve a “mysterious” performance problem for a customer. The problem turned out to be a […]
Data Normalization in PostgreSQL
In his blog "Normalization by Osmosis", Michał Małecki gives you an overview of data normalization in PostgreSQL, including normal forms
Cleaning up a large number of BLOBs in PostgreSQL
Basically, there are two ways to delete BLOBs (binary large objects):Change the PostgreSQL configuration or delete the BLOBs in chunks.
PostgreSQL: int4 vs. float4 vs. numeric
PostgreSQL offers many different data types. This post will focus on three important ones: the integer, float and numeric types.
PostgreSQL: Useful new data types - CREATE DOMAIN
UPDATED 08.05.2023 How to create useful new data types with CREATE DOMAIN in PostgreSQL | Advanced server side check constraints
