PostgreSQL 10 Roadmap
At the PostgreSQL developer meeting we discussed putting up everybody’s roadmap projects in one place: http://wiki.postgresql.org/wiki/PostgreSQL10_Roadmap.
2ndQuadrant PostgreSQL Roadmap Projects
Logical Replication
- Use Case: Upgrade
- Use Case: Partial database replication
- Aiming for a full and complete implementation for 10.0, allowing other use cases to be supported in later releases.
Column Storage & Executor Efficiency
- Indexes
- Columnar Indexes (for Column Store)
- Parallel BRIN scan
- Row insertion using index (BRIN)
- HOT optimizations
Optimizer & Statistics
Our calculations suggest that more statistics will help query planning.
Transactions & Programmability
- Procedures
- Autonomous Transactions
Management features for Replication & Backup
- Bring recovery.conf parameters into postgresql.conf, since it’s v10.0 next
- Allow snapshots on standby servers, allowing parallel backup etc..
Locking & Data Availability
- Further lock reductions for DDL
- WAIT PATIENTLY
Distributed Systems
- Node Registry
- Feeding back from Postgres-XL into Core Postgres
Various other projects as well.
Of the statistics, cross-column statistics are a must, seems that most of the competition is light years ahead there; it would be OK if they need to be manually indicated; currently there is no obvious ways of overcoming this except by doing composite keys or join tables (which, while inefficient, are often faster by many factors than blind join using correlating keys).
Tomas Vondra is working on multivariate statistics patch which will among other things add cross-column statistics.
Good stuff.
What about BDR? Any plans for it in the roadmap?
See https://blog.2ndquadrant.com/postgresql-solutions-roadmap/
It would be great if there would be a complete tutorial on how to upgrade from 9.4 to 9.5 without waiting for 9.6 or 10.0, at least for the simplest use case (single node cluster, 1 database):
– Install pglogical on 9.4 and 9.5
– Configure pglogical (from 9.4 to 9.5)
– Replicate database from 9.4 to 9.5 (with minimal downtime/locking for 9.4 compared to pg_upgrade)
– Synchronize any missing data pglogical cannot replicate automatically (sequences?)
– Change application to write to 9.5 (new “master”, i.e. exchange ports on same machine)
– Disable replication in 9.4 and 9.5
https://2ndquadrant.com/en/resources/pglogical/pglogical-docs/
Where can I read more about the column store, is this separate from the cstore fdw?
Why will recovery.conf Stuff be moved to the postgresql.conf? I love the way it is right now as you can keep the postgresql.conf exactly the same on all recovery Databases…
A number of efforts have been made to do that. So far none have been successfully incorporated into a PostgreSQL release.
Is there any link to article about “Row insertion using index (BRIN)” – it sounds the next best thing to online reorganize and sliced bread..
https://www.postgresql.org/docs/current/static/brin-intro.html