Peeking at query performance of the upcoming version 11 of PostgreSQL
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 not activated by default […]
Ideas for scaling PostgreSQL to multi-terabyte and beyond
After a recent chat with a DBA, who was making 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 to squeeze the last out of the hardware, to safely accommodate decent multi-terabyte size databases. Especially as […]
Are your foreign keys indexed?
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 […]