PostgreSQL – v12 – Importing data from previous version

Background Let us import data from PostgreSQL Version 11 into Version 12. Lineage PostgreSQL – v12 – Installation/Upgrade on MS Windows Link   Outline Previous Instance Start previous Instance Export Data Options pg_dumpall Using pg_dumpall, export data Stop previous Instance New Instance Start new Instance Import Data Options psql Using psql, import data Review imported … Continue reading PostgreSQL – v12 – Importing data from previous version

PostgreSQL – v12 – Installation/Upgrade on MS Windows

Background PostgreSQL Version 12 was released On October 3rd, 2019. That is about two weeks ago. Since then I have wanted to upgrade our Development instance from Version 11 to Version 12. Release Notes A brief summary of the Release Notes are available here.   Installation Outline Here are the steps we will take :- … Continue reading PostgreSQL – v12 – Installation/Upgrade on MS Windows

PostgreSQL – v12 – Release Notes

Background PostgreSQL version 12 was released yesterday, Thursday 2019-Oct-3rd. Features and Enhancements Here are some of the enhancements. Performance Index B-tree Index Indexes utilize up to 40% less storage compared to Version 11 Statistics More reliable statistics on non-uniformly distributed datasets Table Partitioning Better partition elimination when querying limited subset of the data More performant … Continue reading PostgreSQL – v12 – Release Notes