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:
- Table partition.
- 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.
- 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