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 find Default Access Privileges on PostgreSQL with pg_default_acl
- MongoDB 4.2.7 Bug - Off-by-one overflow in block-modification bitmaps for incremental backup
- Failed: error dumping users and roles: error writing data for collection with mongodump
- Easy fix for ERROR 1010 (HY000): Error dropping database
- Overcome the MongoDB Backup is down alert
- How to migrate databases with mongodump and mongorestore
- How to edit a user password with MongoDB Ops Manager
- MariaDB is number function
- How to make MySQL tables case insensitive
- MariaDB EXPLAIN same query - different results on different servers
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
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.
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: |