agile dba,data privacy,data protection, management of information systems, relational, non-relational, structured, non-structured, semi-structured, on-premises, in the cloud
dba-ninja.com:Everything
Search dba-ninja.com
Follow dba-ninja.com
*Use the Comments section for questions
dba-ninja.com Links
Recent Posts
- AWS CLI -- output table format broken on Windows
- How do I create a security group in AWS command line?
- How do I restore my AWS RDS? aws backup start-restore-job example
- What is Serverless Architecture ?
- PostgreSQL doesn't support clustered indexes
- A simple guide to AWS SCT multiserver assessment
- AWS CLI Cheatsheet
- Migrate SQL Server to Aurora PostgreSQL using AWS DMS best practices
- How does format-preserving encryption work?
- How do I disconnect multiple connections on a server ?
What's new in Postgres 12
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
Author: Rambler (http://www.dba-ninja.com)
Share:
Verify your Comment
Previewing your Comment
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: |