A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL"
Why the word "unknown" is better to describe a NULL value than "empty". Learn to use NULL values correctly in PostgreSQL.
Since I only recently learned about the concept of “killed index tuples”, I thought there might be some others […]
Foreign Key Indexing and Performance in PostgreSQL
by
Laurenz Albe |
10.2018Foreign key constraints are an important tool to keep your database consistent while also documenting relationships between tables. A fact […]
PostgreSQL: Parallel CREATE INDEX for better performance
How to use parallel CREATE INDEX in PostgreSQL, which will eliminate various performance bottlenecks - especially for large applications.
Avoiding “OR” for better query performance
by
Laurenz Albe |
05.2018 PostgreSQL query tuning is our daily bread at CYBERTEC, and once you have done some of that, you'll start […]
Tech preview: PostgreSQL 11 - CREATE PROCEDURE
With PostgreSQL 11 the new feature CREATE PROCEDURE has been initiated. This Blogpost is about how to use this PostgreSQL feature.
PostgreSQL: Speeding up analytics and window functions
How to improve speed is by rearranging window functions in a clever way: some clever optimization can give you better database performance.
New features for sequences: gains and pitfalls
by
Laurenz Albe |
02.2018About sequences Sequences are used to generate artificial numeric primary key columns for tables. A sequence provides a “new ID” […]
PostgreSQL: Speeding up GROUP BY and joins
Most people actually implement aggregations slightly wrong in PostgreSQL. This blogpost shows how to spped up group by and joins.
Creating 1 million users in PostgreSQL
“How many users can you have in PostgreSQL?” - “Well, as many as you want.” Here's how to easily create a large number of database users.
