"post-gres" or "post-gres-cue-ell", not "post-gray-something". I heard people making this same mistake in presentations at this past weekend's Postgres Anniversary Conference :-( Arguably, the 1996 decision to call it PostgreSQL instead of reverting to plain Postgres was the single worst mistake this project ever made. It seems far too late to change now, though. regards, tom lane
Wrappers Extensions Common Table Expressions Geospatial capabilities Full text search Fast Column Addition Listen/Notify Table Inheritance Per Transaction Sync. Replication Window Functions JSONB Momentum
a distributed database. You go from one database, to spreading your data set across a single node Think parallel, but across multiple instances not just scaled up
Upsert, lots of small usability improvements Postgres 9.6 Feature frozen 1 week ago Mostly performance improvements Extensions Citus - Horizontally scalable Postgres HLL - Almost exact uniques across large datasets Lots more - explore them at pgxn.org