PostgreSQL 13 Has Some Performance Boosts! Let us discuss it!

The Backend Engineering Show with Hussein Nasser

Episode | Podcast

Date: Sun, 11 Oct 2020 00:55:47 GMT

<p>PostgreSQL 13 Has Some Performance Boosts! Let us discuss it!</p> <p>Postgres 13 has been released and it has some interesting features how about we discuss it!</p> <p>Resources</p> <p>Press-release https://www.postgresql.org/about/featurematrix/detail/341/</p> <p>Feature Matrix <a href="https://www.postgresql.org/about/featurematrix/">https://www.postgresql.org/about/featurematrix/</a></p> <p>“The PostgreSQL Global Development Group today announced the release of&nbsp;<a href="https://www.postgresql.org/docs/13/release-13.html"><strong>PostgreSQL 13</strong></a>, the latest version of the world’s&nbsp;<a href="https://www.postgresql.org/"><strong>most advanced open source database</strong></a>.</p> <p>PostgreSQL 13 includes significant improvements to its indexing and lookup system that benefit large databases, including space savings and performance gains for indexes, faster response times for queries that use aggregates or partitions, better query planning when using enhanced statistics, and more.</p> <p>Along with highly requested features like&nbsp;<a href="https://www.postgresql.org/docs/13/sql-vacuum.html"><strong>parallelized vacuuming</strong></a>&nbsp;and&nbsp;<a href="https://www.postgresql.org/docs/13/runtime-config-query.html#GUC-ENABLE-INCREMENTAL-SORT"><strong>incremental sorting</strong></a>, PostgreSQL 13 provides a better data management experience for workloads big and small, with optimizations for daily administration, more conveniences for application developers, and security enhancements.</p> <p>"PostgreSQL 13 showcases the collaboration and dedication of our global community in furthering the abilities of the world's most advanced open source relational database," said Peter Eisentraut, a PostgreSQL Core Team member. "The innovations that each release brings along with its reputation for reliability and stability is the reason why more people choose to use PostgreSQL for their applications."</p> <p><a href="https://www.postgresql.org/"><strong>PostgreSQL</strong></a>, an innovative data management system known for its reliability and robustness, benefits from over 25 years of open source development from a&nbsp;<a href="https://www.postgresql.org/community/"><strong>global developer community</strong></a>&nbsp;and has become the preferred open source relational database for organizations of all sizes.”</p>