PostgreSQL – Page 2 – ITFROMZERO

Installing PostgreSQL 16 on CentOS Stream 9: A Survival Guide for Production Environments

By admin May 27, 2026

A production-ready guide for installing PostgreSQL 16 on CentOS Stream 9. This article focuses on SELinux, Firewalld security, and practical performance tuning tips.

Database

Optimizing PostgreSQL Dashboards: Speed up Queries 100x with Materialized Views

By admin May 27, 2026

Discover the power of Materialized Views in PostgreSQL. An optimal solution to make dashboards load instantly by storing pre-calculated query results.

Database

Barman: Professional PostgreSQL Production Backup Solution – From WAL Archive to PITR

By admin May 27, 2026

Don't let pg_dump keep you up at night. Detailed guide on using Barman for professional PostgreSQL backup management with second-precision data recovery (PITR).

Database

Scaling PostgreSQL ‘Unlimited’ with Citus: From 1 Billion to Tens of Billions of Records

By admin May 22, 2026

Citus is the leading solution for Horizontal Sharding in PostgreSQL. Learn how to set up a cluster, choose a Shard Key, and optimize performance for systems with billions of records.

Database

Atlas (Ariga): Database Schema Management as Code and Migration Automation

By admin May 21, 2026

Atlas (Ariga) enables IaC-style database schema management: describe your desired state, auto-generate migrations, lint destructive changes, and detect drift between code and your live database. This article compares Atlas with Flyway/Liquibase and walks through a real-world PostgreSQL setup.

Database

Using Debezium for Change Data Capture (CDC) from MySQL and PostgreSQL: Real-Time Sync to Kafka Without Touching Your Application

By admin May 21, 2026

A practical guide to setting up Debezium for real-time Change Data Capture (CDC) from MySQL and PostgreSQL, streaming events to Kafka — no application changes required, just reading the transaction log. Covers Docker Compose setup, connector registration, and common troubleshooting.

Database

PostgreSQL Full-Text Search: High-Performance Vietnamese Search Without Elasticsearch

By admin May 19, 2026

Don't rush to install Elasticsearch! A detailed guide on building high-speed, accurate Vietnamese search directly in PostgreSQL using only tsvector and GIN Index.

Database

Sysbench: How to Measure Real-World Load for MySQL and PostgreSQL (Not Just Theory)

By admin May 10, 2026

A detailed guide on using sysbench to benchmark MySQL and PostgreSQL performance through three stages: Prepare, Run, and Cleanup. Learn how to interpret TPS and Latency metrics to identify database bottlenecks.

Database

Free Your Hands with SchemaSpy: Automating ERD Diagrams and Database Documentation

By admin May 8, 2026

Stop drawing ERD diagrams by hand! A guide to using SchemaSpy for automated database scanning, generating HTML reports, and professional relationship diagrams in minutes.

Database

Database Encryption: Don’t Leave Your Data Exposed with pgcrypto and AES_ENCRYPT

By admin May 5, 2026

Don't let user data leak in plain-text. Learn how to use pgcrypto and AES_ENCRYPT to encrypt sensitive data according to modern security standards.