PostgreSQL – ITFROMZERO – Share tobe shared!

PostgreSQL Monitoring: From ‘Information Blindness’ to a Professional Alerting System

By admin April 6, 2026

Don't wait for a database crash to find out something's wrong. Here is a detailed guide to setting up professional PostgreSQL monitoring with Prometheus and Grafana based on real-world experience.

Database

Database Schema Design: Don’t Let Technical Debt Sink Your System

By admin April 5, 2026

Learn how to design standard database schemas from 1NF to 3NF, the secrets of applying Denormalization to boost performance, and pitfalls to avoid.

Ubuntu

Installing PostgreSQL on Ubuntu 22.04: From Zero to Production Deployment

By admin March 29, 2026

Learn how to professionally install and configure PostgreSQL on Ubuntu 22.04. A guide to creating users, securing remote connections, and managing disk space effectively.

Database

Migrating Data from MySQL to PostgreSQL: Comparing Methods and Practical Guide

By admin March 29, 2026

A guide comparing 3 methods for migrating data from MySQL to PostgreSQL: pgloader, manual mysqldump conversion, and Python ETL. Analyzes the pros and cons of each approach with practical command examples and a post-migration verification checklist.

Database

Optimizing Database Performance for High-Traffic Websites: Practical Experience from ITfromzero

By admin March 25, 2026

For websites to handle immense traffic, database optimization is crucial. This article shares practical experience on strategies from design, query optimization, caching, to monitoring to keep your database robust and stable.

Database

How to Install and Configure PostgreSQL Streaming Replication: Real-time Data Synchronization between Primary and Standby

By admin March 13, 2026

Learn how to set up PostgreSQL Streaming Replication for High Availability and Disaster Recovery. A step-by-step guide to configuration and data synchronization between Primary and Standby.

Docker

Docker Volumes: Persistent Data Storage That Survives Container Restarts

By admin March 8, 2026

Lost an entire database at 2 AM because I forgot to use Docker volumes — here's the hard-won lesson and a guide to configuring volumes correctly for production, including backup and monitoring.

Database

Optimizing PostgreSQL Queries with EXPLAIN ANALYZE: Analyzing and Improving Query Performance

By admin March 8, 2026

Learn how to use EXPLAIN ANALYZE in PostgreSQL to read execution plans, analyze slow queries, and optimize performance with the right indexes. This guide goes from a 5-minute quick start to advanced techniques like covering indexes, composite indexes, and auto_explain.

Database

PostgreSQL Backup Done Right: Strategy, Automation, and Real-World Restore Testing

By admin March 4, 2026

PostgreSQL backup isn't just about running pg_dump and walking away — the more critical part is regular restore testing and monitoring backup file integrity. This post shares a battle-tested workflow with automation scripts, a comparison of pg_dump vs pg_basebackup, and a complete checklist to make sure your backups actually work when it counts.

Database

SQL vs NoSQL: When to Choose Each for Your Project

By admin March 2, 2026

SQL and NoSQL aren't competitors — each solves a different problem. This article breaks down when to choose SQL, when to use NoSQL, and how to combine both in real-world systems.