Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

For 26 years we have focused on building mutual success with Postgres and Open Source. We provide support, professional services, and custom development.

What We Do

Professional Services

For 26 years we have focused on building mutual success with Postgres and Open Source deployments including architecture, consulting, automation and optimization.

24x7x365 Support

We bring white glove service to our clients with Enterprise Wide 24x7x365 support for Postgres and the Full Stack.

PgManage

PgManage is an GUI administrator for Postgres. It is designed to be intuitive and efficient. It is a replacement for legacy management software such as PgAdmin IV. There are Open Source and Enterprise version.

Featured Clients

Items managed

Issues solved

Our clients say

Part 3: Why Autovacuum Stops — PostgreSQL Internal Mechanics Explained

Series Summary: This is Part 3 of a multi-part series on PostgreSQL autovacuum failures.

In Part 2, we reproduced the autovacuum failure issue — now let’s understand why it happens. This post dives into PostgreSQL internals, explaining how autovacuum allocates its resources and why certain databases get “stuck” in maintenance limbo.

Why Does This Occur?

This behavior stems from how the autovacuum daemon allocates its resources. Autovacuum identifies the database with the oldest XID, and prioritizes it by assigning all available background workers to that database. As a result, …