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 | Contact
Search dba-ninja.com
Follow dba-ninja.com
dba-ninja.com Links
Recent Posts
- How to import a csv file with a header into a PostgreSQL table
- How to migrate MongoDB data to PostgreSQL using mongoexport
- How to get DSN list from remote servers using Powershell
- What is the Avro data format
- PostgreSQL Foreign Data Wrapper
- What's new in Postgres 12
- How to create a MongoDB change stream application
- How to read MongoDB system log file
- Apache Kafka FAQ
- How to find PostgreSQL server messages logs
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: |