Planet PostgreSQL – Peter Eisentraut: PostgreSQL hidden gems

There is a PostgreSQL major release every year, and every release has
about 200 changes listed
in the release notes. A handful of those are typically listed at the
top as “major items”, which are highlighted for the benefit of the
public. Sometimes, a feature that was not highlighted as major turns out later
to have a significant impact. Consider these features that flew under
the radar at the time: PostgreSQL 9.4: replication slots This is the one that always comes to my mind when I think back about “hidden gems”. At the time perhaps not fully understood, replication slots are now absolutely essential for any replication setup. PostgreSQL 9.5: pg_rewind pg_rewind existed as an external project outside…

External feed Read More at the Source: https://postgr.es/p/5Aj