28 August,2019 by Rambler
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
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |