PostgreSQL – ITFROMZERO – Share tobe shared!

vCenter Frozen Due to Full /storage/db? A Definitive Guide for Sysadmins

By admin August 29, 2026

vCenter freezing with a 503 Service Unavailable error is often caused by a 100% full /storage/db partition. Here's how to safely expand disks and clean up the PostgreSQL DB.

Docker

Setting Up Wiki.js with Docker Compose: A ‘Fast-Light-Simple’ Knowledge Management Solution

By admin August 22, 2026

A detailed guide on setting up Wiki.js with Docker Compose. This article focuses on optimized configuration, PostgreSQL database management, and practical operation tips for dev teams.

Development

Using sqlc for Database Management in Go: Real-world Performance and Absolute Type-safety

By admin August 18, 2026

Why does sqlc outperform traditional ORMs in Go? Discover how sqlc boosts system performance and minimizes runtime errors by generating code from raw SQL.

Docker

Dockerize Strapi CMS: Professional Headless CMS Deployment with PostgreSQL and Docker Compose

By admin August 17, 2026

Forget about tedious environment setup. This guide helps you Dockerize Strapi CMS with PostgreSQL, optimize image size, and ensure smooth operation on any server.

Database

PostgreSQL Optimization: Using Partial and Covering Indexes to Reduce Storage by 90% and Speed Up Queries

By admin August 16, 2026

Don't let indexes slow down your system. Discover how to combine Partial and Covering Indexes in PostgreSQL to optimize performance and save storage space effectively.

Database

Real-time PostgreSQL Monitoring with pg_activity: Kill Hung Queries in a Flash

By admin August 14, 2026

Don't let slow queries crash your server. Learn how to use pg_activity on Linux for real-time PostgreSQL monitoring, detecting idle in transactions, and handling hung queries quickly.

Database

pg_repack Guide: Efficiently Resolving PostgreSQL Bloat with Zero Downtime

By admin August 11, 2026

PostgreSQL bloat wastes resources and degrades performance. Discover how to use pg_repack to efficiently reclaim disk space with zero downtime.

Docker

Dockerizing Odoo ERP: Production-Ready Deployment with PostgreSQL and Nginx

By admin July 28, 2026

Professional Odoo ERP installation with Docker Compose. Detailed guide on Multi-container configuration, Nginx Reverse Proxy optimization, and worker calculation tips for peak performance.

Artificial Intelligence tutorial - IT technology blog

Building a ‘Self-Service’ PostgreSQL AI Agent with PandasAI: From 1 Hour to 1 Minute

By admin July 15, 2026

Don't let SQL waste your time. Discover how to combine PandasAI and PostgreSQL to build an automated data analysis system, reducing your daily reporting workload by 70%.

Database

Database Branching with Neon: End Your Fear of Broken Migrations in Production

By admin July 14, 2026

Leverage Database Branching and Serverless PostgreSQL with Neon to take your CI/CD pipeline to the next level. A detailed guide on safely testing schema changes against real data without risking a production outage.