"LOCK TABLE" can harm your database's health
by
Laurenz Albe |
03.2019 Many people know that explicit table locks with LOCK TABLE are bad style and usually a consequence of bad […]
PostgreSQL affiliate projects for horizontal multi-terabyte scaling
Don’t be afraid to scale up with Postgres: Overview about PostgreSQL extensions and derivatives for horizontal multi-terabyte scaling.
PostgreSQL: Implicit vs. explicit joins
How to use implicit and explicit joins in PostgreSQL. What are the performance differences between these two types of join?
Since I only recently learned about the concept of “killed index tuples”, I thought there might be some others […]
Query performance of the upcoming version 11 of PostgreSQL
Release notes of first RC of PostgreSQL 11 didn't state any numerical query performance indicators, so we have to find it out on our own.
Ideas for scaling PostgreSQL to multi-terabyte and beyond
Features and "hacks" for scaling PostgreSQL to multi-terabyte and beyond. Ways to safely accommodate decent multi-terabyte size databases.
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.
Sort Performance in PostgreSQL
How to speed up and improve sort performance in PostgreSQL. Shows the many cases where it makes sense to avoid sorting by using indexes.
3 ways to detect slow queries in PostgreSQL
How to fix bad performance in PostgreSQL - shows three useful and quick methods to spot performance problems and slow queries.
