Tag: #postgresql
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 60 posts
Running Databases on Kubernetes Complete Guide: StatefulSet, Operators, Backup and Recovery
Everything about running DBs on K8s! StatefulSet vs Deployment, PV/PVC/StorageClass, DB Operators (CloudNativePG/Percona/MongoDB), Backup/Recovery (Velero/pgBackRest), Monitoring (PMM), HA/Failover, Performance Tuning, P
2026-03-24 · 17 min read #kubernetes#database#statefulset#operator#postgresqlDatabase Performance Tuning Complete Guide: Query Optimization, Index Strategy, Connection Pool Management
Everything about DB performance tuning! EXPLAIN ANALYZE interpretation, index design (B-Tree/GIN/BRIN), slow query analysis, connection pooling (HikariCP/PgBouncer), N+1 resolution, partitioning, read replicas, query cac
2026-03-24 · 22 min read #database#performance#tuning#indexing#query-optimizationSQL Mastery 2025: Developer Interview SQL — From JOINs to Window Functions and Query Optimization
Everything about SQL interviews! 7 types of JOINs, Window Functions (ROWNUMBER/RANK/LAG/LEAD), Subquery vs CTE, Index internals (B-Tree/Hash/GIN), EXPLAIN ANALYZE, Transaction Isolation Levels, and 30 practice problems.
2026-03-23 · 30 min read #sql#database#join#window-function#indexingDatabase Complete Comparison 2025: PostgreSQL vs MySQL vs MongoDB vs Redis — Selection Guide
Everything about database selection in 2025! PostgreSQL (JSONB+pgvector), MySQL (HeatWave ML), MongoDB (Atlas Vector Search), Redis (Stack/Search) — architecture, performance benchmarks, cost comparison, use-case selecti
2026-03-23 · 29 min read #database#postgresql#mysql#mongodb#redisSpring Boot Database Connection Complete Guide: JPA, HikariCP, Transactions, QueryDSL, Multi-DB
Complete guide to Spring Boot database integration — JPA/Hibernate configuration, HikariCP connection pool optimization, transaction management, QueryDSL, multi-datasource, R2DBC, and slow query logging.
2026-03-17 · 10 min read #spring-boot#jpa#hikaricp#querydsl#transactionSpring Boot Flyway Complete Guide: Database Migration Strategy and Production Patterns
Complete guide to database migration with Flyway in Spring Boot — versioning strategy, multi-environment configuration, test strategies, Java-based migrations, and production deployment patterns.
2026-03-17 · 11 min read #spring-boot#flyway#db-migration#jpa#postgresqlDatabase Engineering Complete Guide: From SQL to Vector DBs and AI RAG Systems
A comprehensive database engineering guide for the AI era — covering advanced SQL, pgvector similarity search, Pinecone, Redis caching, distributed systems theory, and building RAG pipelines with LangChain.
2026-03-17 · 18 min read #database#postgresql#vector-database#pgvector#ragPostgreSQL Query Optimization and Performance Tuning Practical Guide: From EXPLAIN to Partitioning
A systematic guide to practical performance optimization techniques for PostgreSQL including EXPLAIN analysis, index strategies, VACUUM tuning, partitioning, and connection pooling.
2026-03-14 · 19 min read #database#postgresql#query-optimization#performance#indexingPostgreSQL VACUUM, MVCC, and Bloat Optimization Guide
A comprehensive guide to PostgreSQL VACUUM, MVCC internals, and table bloat optimization for maintaining database performance.
2026-03-12 · 19 min read #database#postgresql#vacuum#mvcc#autovacuumPostgreSQL Advanced Indexing Guide: GIN, GiST, BRIN, and Partial Index in Practice
A deep dive into PostgreSQL advanced index types. Beyond B-tree, we explore GIN (inverted index), GiST (spatial index), BRIN (block range index), Partial/Expression Index internals, real-world use cases, EXPLAIN ANALYZE-
2026-03-10 · 16 min read #database#postgresql#indexing#gin-index#performanceTimescaleDB Time Series Database Operations Guide
A practical operations guide for TimescaleDB time series database, covering hypertable design, continuous aggregates, compression, and retention policies.
2026-03-09 · 16 min read #database#timescaledb#time-series#postgresql#2026-03TimescaleDB Time Series Database Operation Guide: From Hypertable Design to Continuous Aggregation and Compression Optimization
A comprehensive operations guide that covers TimescaleDB's Hypertable architecture and chunk management, Continuous Aggregates settings, 90% storage reduction with native compression, data retention policy, and productio
2026-03-07 · 22 min read #database#timescaledb#postgresql#time-series#hypertablePostgreSQL Partitioning Production Guide: Range, List, and Hash Strategies for Billion-Row Tables
A comprehensive guide to PostgreSQL table partitioning covering range, list, and hash strategies, partition pruning optimization, pgpartman automation, zero-downtime migration from monolithic tables, and production maint
2026-03-07 · 17 min read #database#postgresql#partitioning#performance#billion-row-tablesPostgreSQL 17 Partitioning and Parallel Query Guide
A comprehensive guide to PostgreSQL 17 partitioning strategies and parallel query optimization for large-scale databases.
2026-03-06 · 15 min read #database#postgresql#partitioning#parallel-query#2026-03PostgreSQL Index Tuning Patterns 2026
PostgreSQL Index Tuning Patterns 2026 - A Practical Application Guide Based on 2026 Standards
2026-03-04 · 25 min read #database#postgresql#2026-03PostgreSQL Partitioning Complete Guide: Range, List, Hash Strategies and Performance Optimization
Learn how to dramatically improve the performance of large tables using PostgreSQL declarative partitioning. Covers Range, List, and Hash partitioning strategies along with partition pruning and automated management.
2026-03-03 · 21 min read #database#postgresql#partitioning#performance#query-optimizationPostgreSQL Partitioning Practical Guide
Covers PostgreSQL Range/List/Hash partitioning methods, partition pruning, automation strategies, and operational tips with practical examples.
2026-03-03 · 24 min read #database#postgresql#partitioning#2026-03SQL Practical Cheatsheet — Complete Reference for Everyday Commands
From SELECT, UPDATE, INSERT, DELETE to subqueries, window functions, CTEs, index strategies, and execution plan analysis. All the SQL patterns you use daily in one place. Copy and use right away.
2026-03-02 · 36 min read #database#sql#mysql#postgresql#selectPostgreSQL + pgvector Vector Search Practical Guide: From RAG to Hybrid Search
Implement vector similarity search with the PostgreSQL pgvector extension. Covers installation through HNSW/IVFFlat indexes, hybrid search (vector + full-text search), and RAG pipeline integration with practical code.
2026-03-02 · 9 min read #postgresql#pgvector#vector-search#embedding#ragPostgreSQL Performance Tuning Practical Guide — Query Optimization, Index Strategy, EXPLAIN Analysis
A hands-on guide to the core of PostgreSQL performance tuning. Covers how to read EXPLAIN output, index strategies, query optimization patterns, and configuration tuning with practical code examples you can apply immedia
2026-03-02 · 11 min read #database#postgresql#performance#sql#indexing