Month: October 2018
Query performance of the upcoming version 11 of PostgreSQL
By Kaarel Moppel – Last week the first release candidate of the upcoming Postgres version 11 was released, stating that everything is going more or less as planned – great news! The 11 release is promising a lot of very cool stuff as usual, including – better partitioning, more parallezation and JIT capabilities (which are […]
Ideas for scaling PostgreSQL to multi-terabyte and beyond
By Kaarel Moppel: After a recent chat with a DBA who was taking his first steps towards migrating a big database away from Oracle to Postgres, I thought there are not enough articles on PostgreSQL features and “hacks” to achieve scalability. People want to know how to squeeze the last out of the hardware and […]
Foreign Key Indexing and Performance in PostgreSQL
Foreign key constraints are an important tool to keep your database consistent while also documenting relationships between tables. A fact that is often ignored is that foreign keys need proper indexing to perform well. This article will explain that and show you how to search for missing indexes. Index at the target of a […]