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
For any Database issues send email to: jackvamvas@gmail.com
dba-ninja.com Links
Recent Posts
- How to do a MariaDB Restore
- Default Isolation Levels across database systems
- What is the Disk Capacity and Partition Amounts for GPT and MBR
- Top signs of an inexperienced DBA
- Chaos engineering and databases
- Building Secure and reliable systems
- How to MySQL restore files from a directory backup to their original location
- Explain the difference between one-way trust and two-way trust
- How to use Database Reliability Engineering to Increase Database availability
- How to automatically delete MongoDB documents after a certain time with TTL indexes
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: |