Articles by tag: postgresql

Special ClickHouse Engines: When MergeTree Is Not Needed

Overview of ClickHouse Memory, Buffer, Null, Log, URL, S3, and PostgreSQL Engines. Examples for coefficient cache, buffering inserts from Kafka, and live data from external databases.

BufferPin conflicts in PostgreSQL: how to find and fix

Breaking down hidden BufferPin conflicts in PostgreSQL that affect replicas and autovacuum. Diagnostic, monitoring, and optimization methods for DBAs and developers.

Next.js Integration with 1C Bitrix: Asynchronous Lead Transfer

Implement reliable lead transfer without queues. Detailed breakdown of the pattern with after(), retry, and error handling. Learn how to avoid Bitrix REST API timeouts.

Observability in Go: QueryTracer, metrics and OTel

Comparing observability tools in Go: QueryTracer, metrics and OpenTelemetry. Learn when to use each and how to avoid implementation errors.

Hybrid Search in PostgreSQL | VectorChord Setup

We break down the infrastructure setup for hybrid search on PostgreSQL and VectorChord. Automation of extensions, table design, processing pipelines. Learn how.

PostgreSQL Analysis: Epistemological Approach to Performance Incidents

How to Combine PG_EXPECTO Technical Analysis with Philosophical Methodologies for Reliable Incident Diagnosis. Quantifying Confidence and Critical Thinking Methods.

PostgreSQL Tuning: AI vs Load Tests

Comparison of AI Recommendations and Real PostgreSQL Benchmarks. Learn how OLTP and OLAP configs affect performance and why tests are more important than theory.

Linux 7.0 regression PostgreSQL ARM64

Amazon developer found PostgreSQL performance drop by 2x on Linux 7.0 due to PREEMPT_LAZY. Analysis, fixes with rseq and Zijlstra's position. Test on ARM64.

Database Architecture for Parsing Tariffs on PostgreSQL

Study the star schema for storing internet and TV tariffs: fact tables, dimensions, historicity triggers, indexes. Full SQL code for middle/senior developers. Implement provider monitoring without data loss.

Master C# from Scratch: Free Program

Get C# Developer Skills for Free: From CS Basics to ASP.NET Core and EF Core. Full 8–10 Month Plan with Courses and Tips for Junior Positions. Start Now!

ltree in PostgreSQL with JPA: storing trees

Integration of ltree for hierarchical data in PostgreSQL and JPA. Performance comparison with recursive SQL. Application in microservices for developers.

BI system on DataLens and PostgreSQL for WB Ozon

Learn how to build a scalable BI system for marketplaces: from API export to optimized dashboards. Cost versioning, precalculations, automation. Instructions for developers.

QR Ticket Validation Design for Cinemas

Breakdown of System Design for QR Ticket Validation: offline signature, idempotency, atomic updates. Solving timeouts and HoL blocking for high-load. Practical SQL examples.

PostgreSQL Recovery without 2.5 TB Backup

Real case of PostgreSQL cluster destruction from WAL deletion and SIGKILL. Recovery steps with ignore_system_indexes, crash_info and pg_dump patches. Lessons for 1C DBA.

Health Score for PostgreSQL: health monitoring

Learn how Health Score combines 150 PostgreSQL metrics into one indicator. Formulas, SQL queries, category weights and auto-diagnostics for DBA. Implement in your infrastructure.

pgvector vs pgvectorscale vs VectorChord: comparison

Technical comparison of PostgreSQL extensions for vector search: pgvector, pgvectorscale, VectorChord. Benchmarks, HNSW/DiskANN indexes, RaBitQ compression. Docker setup and code for 1M records. Choose the optimal solution.

Master PM tech stack: AI assistant on FastAPI

Step-by-step guide for PM: SaaS development with FastAPI, PostgreSQL, RAG. 10 stages from Telegram bot to hybrid search. Deepen the technique without simplifications.

Uniform DB Sharding: Data Distribution and Search Strategies

Explore uniform sharding methods for horizontal scaling of databases. Learn about ID generation, paging, and query optimization in distributed systems.