PostgreSQL

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.

XID WrapAround is perhaps a unique type of failure specific to PostgreSQL

If you use Integer sequences on tables, you should consider potential overflow scenarios.

Detailed understanding of trigger management and usage in PostgreSQL

A common requirement in application development is GeoIP conversion - converting source IP addresses to geographic coordinates or administrative divisions (country-state-city-county-town-village)

Without rules, there can be no order. This article compiles a development specification for PostgreSQL database principles and features, which can reduce confusion encountered when using PostgreSQL.

PostgreSQL’s slogan is “The World’s Most Advanced Open-Source Relational Database,” but I think the most vivid characterization should be: The Full-Stack Database That Does It All - one tool to rule them all.

Ultimate optimization of KNN problems, from traditional relational design to PostGIS

How to efficiently solve the typical reverse geocoding problem: determining administrative regions based on user coordinates.

Tables in PostgreSQL correspond to many physical files. This article explains how to calculate the actual size of a table in PostgreSQL.

PgAdmin is a GUI program for managing PostgreSQL, written in Python, but it’s quite dated and requires some additional configuration.

Recently there was a perplexing incident where a database had half its data volume and load migrated away, but ended up being overwhelmed due to increased load.

Exclude constraint is a PostgreSQL extension that can implement more advanced and sophisticated database constraints.

PostgreSQL functions have three volatility levels by default. Proper use can significantly improve performance.

Use Distinct On extension clause to quickly find records with maximum/minimum values within groups

Cars need oil changes, databases need maintenance. For PG, three important maintenance tasks: backup, repack, vacuum

Backup is the foundation of a DBA’s livelihood. With backups, there’s no need to panic.

Pgbouncer is a lightweight database connection pool. This guide covers basic Pgbouncer configuration, management, and usage.

PgBackRest is a set of PostgreSQL backup tools written in Perl

Data migration typically involves stopping services for updates. Zero-downtime data migration is a relatively advanced operation.

Although PostgreSQL provides pgbench, sometimes you need sysbench to outperform MySQL.

FIO is a convenient tool for testing disk I/O performance

It’s recommended to configure PostgreSQL’s log format as CSV for easy analysis, and it can be directly imported into PostgreSQL data tables.

Indexes are useful, but they’re not free. Unused indexes are a waste. Use these methods to identify unused indexes.

Quick configuration for passwordless login to all machines

Wireshark is a very useful tool, especially suitable for analyzing network protocols. Here’s a simple introduction to using Wireshark for packet capture and PostgreSQL protocol analysis.

With file_fdw, you can easily view operating system information, fetch network data, and feed various data sources into your database for unified viewing and management.

PostGIS is PostgreSQL’s killer extension, but compiling and installing it isn’t easy.

top, free, vmstat, iostat: Quick reference for four commonly used CLI tools

Similar to JDBC, Go also has a standard database access interface. This article details how to use database/sql in Go and important considerations.

Cleverly utilizing PostgreSQL’s Notify feature, you can conveniently notify applications of metadata changes and implement trigger-based logical replication.

Sometimes we want to record important metadata changes for audit purposes. PostgreSQL triggers can conveniently solve this need automatically.

Five minutes, PostgreSQL, and the MovieLens dataset—that’s all you need to implement a classic item-based collaborative filtering recommender.

UUID properties, principles and applications, and how to manipulate UUIDs using PostgreSQL stored procedures.

Recently had business requirements to access MongoDB through PostgreSQL FDW, but compiling MongoDB FDW is really a nightmare.