What's new in Postgres 12

28 August,2019 by Jack Vamvas

Postgres 12 is released and being tested across different organisations. 

I'm researching these new Postgres features/enhancements  Big focus on performance & optimisation

Partitioning - Partition tables can now be referenced as foreign keys

Btree - Lots of small changes, but big performance  improvement , and less storage requirements for multi-column indexes

Most-common-value statistics - Allow most-column-value statistics for multiple columns; previously only a single correlation value was recorded for multiple columns.This feature will allow the DBA to create multi column statistics for specific use cases

Inline many CTE queries - Overcome optimization barriers

Prepared plan control - Prepared statements usually use prepared plans after 6 executions.Using the  plan_cache_mode will  force the plan immediately. 

Just-in-time compilation - Useful for datawarehouse queries . Turned  on by default

Checksums control - Enable checksums without having to dump out data.Overcome the painful experience of dumping out data and reimporting!

Reindex concurrently- Supports REINDEX with minimal locking

More news on Postgres 12 

 


Author: Jack Vamvas (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on What's new in Postgres 12


dba-ninja.com