Under the covers Postgres keeps a lot of stats about your data in order to better execute queries. Here’s the first part of a series that starts to tell you everything you could want to know about how it works.
The Citus extension that helps scale out Postgres has a new release including tenant isolation for multi-tenant apps, new reference table APIs, view support for distributed tables, and distributed vacuum/analyze.
In this recording from VividCortex's live webinar, Baron Schwartz discusses some of the new features and capabilities available in MySQL 8.0 and PostgreSQL 9.6. Watch to learn how MySQL and PostgreSQL have changed with these most recent updates.