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:

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

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

Notify of

Sort by:   newest | oldest | most voted
10 months 11 days ago

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.

9 months 7 days ago

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!

7 months 27 days ago

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