PostgreSQL Upgrade --> 9.6

RdbHost, as you know, is a thin security layer (with some auxiliary services) around the PostgreSQL database. The database has been upgraded to version 9.6.

To see all the feature improvements, study the postgres release notes, but a few that caught my notice were:

  • 'upsert' capability, where a key violation on insert can be converted to an update.
  • row-level security on tables, so different rows in same table can have different lock statuses.
  • the full-text search can search phrases (specific word sequences), not just words.


comments powered by Disqus