Our Blogs

PostgresSQL 10 Gets Better With Advanced Features For Developers

December 25, 2017
PostgresSQL 10 was released a few days back. If you had worked with PostgresSQL, you know that it is a popular RDBMS. The main reason for the popularity of PostgresSQL is because of its reliability, cost, maturity, regular updates in addition to open source. You can work with it without any payment.

With PostgresSQL 10, the native partitioning has been simplified by virtually eliminating the requirement of triggers in the master table. You should note that the creation of partitioned tables is now simple. Moreover, querying and inserting of data to these tables is identical to that of a non-partitioned table. The multicolumn statistics has been improved to a great extent.

With PostgresSQL 10, the query planner will be able to avoid edge cases by creating a relationship between different columns. It can be used in cases where the actual where clause is more selective and slows down the total execution time. Moreover, the mechanism of Parallelism has improved to a great extent. As a developer, you can make use of the index, index-only scans, bitmap heap scans in addition to parallel merge joins.

You can configure parallel tables as per the requirement of the project. You can enable it on tables greater than 8MB size and indexes greater than 512KB using 8 workers. The PostgresSQL 10 has added support for full-text search in JSON and JSONB type columns. You can directly search for the values on JSON fields as soon as you create a language-specific full-text index.

If you work with PostgresSQL 10, you will notice improvements to the identity or auto-increment columns. The new mechanism conforms to the latest SQL standards to enable easy migration between various databases. The developers have dropped floating point timestamps support and modified pg_dump and pg_basebackup tool. Furthermore, the version numbering has been changed from 3 to 2 parts.