PostgreSQL 11, the next major release of the world’s most advanced open source database, is just around the corner. The new release of PostgreSQL will include enhancements in partitioning, parallelism, SQL stored procedures and much more.
To give PostgreSQL enthusiasts a deeper look into the upcoming release, 2ndQuadrant hosted a Webinar discussing the new features in PostgreSQL 11. The webinar was presented by Peter Eisentraut, Core Team Member and Major PostgreSQL Contributor.
If you weren’t able to make it to the live session, you can now view the recording here.
Questions that Peter couldn’t respond to during the live webinar have been answered below.
Q: Could you use a custom hash function for partitioning? (or is this in future plans)
A: This is currently not planned.
Q: As far as i understand, there are still no global indexes on partitioned tables. Am i right?
A: Right, these are only local indexes that get automatically added to new partitions and can be managed more simply. Global indexes would be a separate feature that is not currently on the horizon.
Q: What about commit in function? Is this available as well?
A: Commit and rollback are only possible in procedures.
Q: Will JIT-enabled builds be available through PGDG?
A: Yes, community produced Debian and RPM packages will have LLVM support. It might be in a separate sub-package. But some older operating systems don’t have a recent enough LLVM version, so in that case it won’t be available.
Q: Does JIT inlining work with user-defined operators?
A: Yes. The extension module needs to be built in a certain way to install the associated LLVM bitcode. But the normal extension build system takes care of that.
Q: Are JIT compiled queries cached? So they can be reused either by the same session or another session.
A: No, the result of JIT compilation is not cached. This was considered but was not deemed worthwhile at this time.
Q: What about TDE in PostgreSQL 11?
A: TDE is not in PostgreSQL 11. We are not aware currently of anyone working on it.
Q: Can we expect data at rest encryption enhancements in PostgreSQL 12?
A: I would guess not, but you never know.
For any questions, comments, or feedback, please visit our website or send an email to webinar@2ndquadrant.com.
The complete list of new features, enhancements and improvements is available here.