Pigsty Blog Articles

When GIN indexes are used to search with very long keyword lists, performance degrades significantly. This article explains why GIN index keyword search has O(n^2) time complexity.

Replication is one of the core issues in system architecture.

There are various backup strategies. Physical backups can usually be divided into four types.

Thou shalt not run a prod database inside a container

A proper understanding of time is very helpful for correctly handling time-related issues in work and life. For example, time representation and processing in computers, as well as time handling in databases and programming languages.

Sometimes, interactions between components manifest in subtle ways. For example, using pg_dump to export data from a connection pool can cause connection pool contamination issues.

Using binary editing to repair PostgreSQL data pages, and how to make a primary key query return two records.

PostgreSQL uses MVCC as its primary concurrency control technology. While it has many benefits, it also brings other effects, such as relation bloat.

TimescaleDB is a PostgreSQL extension plugin that provides time-series database functionality.

PipelineDB is a PostgreSQL extension for streaming analytics. Here’s how to install it and build continuous views over live data.