PostgreSQL 13 Features Distilled

PostgreSQL 13 Features Distilled

There are many features that have come with this new release but we've only covered some of the main ones listed on the PostgreSQL's official release. Parallel Vacuum of Indexing. Better Statistics for the Query Optimizer & Planner. Incremental Sorting. B-Tree Cost Optimization using Deduplication.

Just a couple of weeks ago, I wrote about MySQL 8.0 going GA on Google Cloud making its journey complete on all the major cloud platforms. MySQL 8.0 has been around for some time now. The open source database community was eagerly waiting for PostgreSQL’s the major release version 13. PostgreSQL is the second most popular open-source database after MySQL and is catching up with increasing adoption across all geographies and industries because of the inherent extensible nature. With AWS Redshift going the PostgreSQL route, world class geospatial support in PostGIS and the amazing set of core features, PostgreSQL is hardly a database that you can ignore.

A week ago, on 24th September, PostgreSQL 13 was released. There are many features that have come with this new release but we’ve only covered some of the main ones listed on the PostgreSQL’s official release.

Parallel Vacuum of Indexing

Vacuuming is a slow and tedious process but unlike other databases, PostgreSQL uses it to reclaim any unused space on disk. When vacuum is run on any given table, the indexes created on that table are also vacuumed. PostgreSQL 13 has introduced a feature where multiple indexes on a table can be vacuumed parallely.

The degree of parallelisation can be set using a data base variable called **max_parallel_maintenance_workers**. This should be set to the number of indexes that the table has.

This, along with a lot of other indexing improvements make this version of PostgreSQL 13 a lot more attractive. Maybe Uber will consider moving back to PostgreSQL after all, just kidding!

P.S. — Beware that this feature is not yet supported for autovacuum. There are a couple of other improvements for autovacuum listed here.

data-engineering postgres programming database software-development

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Software Developer vs Software Engineer — Differences: Bogus or Real?

In this article, see if there are any differences between software developers and software engineers. What you’re about to read mostly revolves around my personal thoughts, deductions, and offbeat imagination. If you have different sentiments, add them in the comment section, and let’s dispute! So, today’s topic…

Offshore Software Development - Best Practices

To make the most out of the benefits of offshore software development, you should understand the crucial factors that affect offshore development.

5 Core Criteria for Selecting Software Development Company -

Check out these five criteria for the selection of your software vendor, and you will never regret having the wrong quality product made for you.

Do you have the Software Engineer and Data Scientist skills?

Becoming a reliable software engineer or data scientist developer, and prepare for production level coding requires a few techniques.

Wrestling Betting Software Development | WWE Betting Software Developers

Wrestling betting software development solutions from expert Wrestling betting app and software development company delivers ultimate betting experience. Chat with us.