PostgreSQL: New Powerful feature of PostgreSQL 9.4

In this post, I am providing short note on the new feature of PostgreSQL 9.4.

PostgreSQL 9.4 has one of the best feature that I have liked it JSON data type.

PostgreSQL 9.4 New Features:

  • JSONB Binary JSON Storage Data Type: You don’t require to take a decision between RDBMS and NOSQL because you can have now both at the same time.
  • Replication Slots: The information is available to the primary server, when the standby server is offline or disconnected.
  • Changeset Streaming/Logical decoding:
    It supplies a new API for filtering, reading and manipulating the replication stream.
  • GIN indexes now faster and smaller:
    pg_prewarm: This is also one of good parameter. When you restart your PostgreSQL Server, shared buffer is empty again. But using this parameter you can take backup of buffer as well.
  • ALTER SYSTEM: you can change your system setting using this ALTER SYSTEM and don’t require to edit postgresql.conf.
  • Improvement in Updatable view.
  • WITH ORDINALITY: A column containing an ordered sequence of numbers is added.
  • Added some new aggregate features.

Reference taken from this URL:

Anvesh Patel

Leave a Reply

3 Comments on "PostgreSQL: New Powerful feature of PostgreSQL 9.4"

Notify of
Sort by:   newest | oldest | most voted

Pretty section of content. I just stumbled upon yoyr site and
in accession capital to assert that I acquire actujally enjoyed acccount your
blog posts. Anyway I will be subscribing to our augment and
even I achievement you access consistentpy fast.


I do not even know how I ended up here, however
I believed this post was once great. I do not know who you are
but certainly you’re going to a well-known blogger
when you aren’t already. Cheers!


I used to be able to find good info from your blog posts.