Home 2015 November PostgreSQL: New Powerful feature of PostgreSQL 9.4

PostgreSQL: New Powerful feature of PostgreSQL 9.4

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

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

PostgreSQL 9.4 has one of the best features 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 the good parameters. When you restart your PostgreSQL Server, the 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.
  • REFRESH MATERIALIZED VIEW CONCURRENTLY.
  • 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
SQL Server: Script to find Estimated Finish Time of The Restore DatabaseMySQL: The Main difference between InnoDB and MyISAM
Comments: 4
  1. freya
    December 15, 2015 at 2:53 am

    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.

  2. Leonel
    January 19, 2016 at 9:55 am

    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!

  3. Derrick
    February 29, 2016 at 5:19 pm

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

  4. Jeff
    November 1, 2019 at 9:46 am

    Good day Avesh.

    Thank you for sharing your knowledge and expertise on this forum. I have been working with PostgreSQL for a few years yet I always seem to pick up a jewel here.
    Your posts relating to postgres configurations / checkpoints were insightful to say the least.

    Many thanks again.

Anvesh Patel
Anvesh Patel

Database Engineer

November 25, 2015 PostgreSQL, , , , , , , , , , , ,