Personally excited about the new version of Postgresql V10. It’s still in beta stage but it has following exciting new features that I have been waiting for:

  1. Table partition.
  2. A genuine identify column. The previous serial is implemented by a separate sequence. Now with the genuine identity column, there is no need to manage a separate  db object.
  3. Built-in support for logical replication. It’s still in its simple form but does the job that a table can be replicated to a remote server. In most cases this is good enough. Refer to this post for detail: https://blog.2ndquadrant.com/postgresql-10-identity-columns/

More details, refer to this https://wiki.postgresql.org/wiki/New_in_postgres_10

Postgresql 10 new features
Tagged on:                 

Leave a Reply

Your email address will not be published. Required fields are marked *

73 − 66 =

This site uses Akismet to reduce spam. Learn how your comment data is processed.