2d ago · 4 min read · PostgreSQL Parallel Query: Configuration & Performance Tuning I was helping a team optimize their reporting pipeline. Their aggregation queries against a 100M-row table were taking 30+ seconds each. They had a 32-core server with plenty of RAM. When ...
Join discussion
Mar 14 · 4 min read · One of the most common misunderstandings when debugging Java applications running on the JVM is this: High memory usage does not necessarily mean there is a memory leak. Many engineers immediately s
Join discussion
Mar 10 · 5 min read · TimescaleDB Memory Tuning: shared_buffers, work_mem, and Chunk Sizing I frequently encounter TimescaleDB deployments where the team has followed standard PostgreSQL tuning advice -- 25% shared_buffers, bump work_mem a bit, set effective_cache_size --...
Join discussionMar 9 · 15 min read · PostgreSQL Performance Tuning: The Complete Practical Guide The default PostgreSQL configuration is designed to run on a Raspberry Pi. If you are running production workloads on default settings, you are leaving 80% of your hardware's capability on t...
Join discussion
Mar 6 · 5 min read · Tuning pgvector Queries: Probes, ef_search, and Distance Functions Here is a question for anyone running pgvector in production: what is the recall of your similarity search? Not the latency, not the throughput -- the recall. What percentage of the t...
Join discussion
Mar 2 · 4 min read · PingDirectory performance tuning involves optimizing the configuration and settings of PingDirectory to handle large volumes of LDAP traffic efficiently. This ensures that your identity and access management (IAM) system remains responsive and scalab...
Join discussionFeb 26 · 6 min read · PostgreSQL Autovacuum Tuning: A Practical Guide Here's a question that separates experienced PostgreSQL operators from everyone else: how many dead tuples does your busiest table accumulate before autovacuum kicks in? If you're running defaults on a ...
Join discussionAug 14, 2025 · 4 min read · Se você está começando sua jornada como DBA ou desenvolvedor SQL, entender wait types é essencial para diagnosticar gargalos de performance com precisão — sem adivinhar. Neste guia, você vai ver o que são waits, por que importam, como consultá-los e ...
Join discussion
Aug 4, 2025 · 17 min read · Introdução Triggers (gatilhos) no SQL Server são objetos de banco de dados que contém código T-SQL executado automaticamente em resposta a determinados eventos no servidor. Diferentemente de stored procedures, não podemos invocar uma trigger diretame...
Join discussion
Jul 20, 2025 · 4 min read · inchirags@gmail.com Chirag's PostgreSQL DBA Tutorial https://www.chirags.in ***************************************************************************************** Installation, Configuration & Tuning of PostgreSQL 17 and pgAdmin4 in Ubuntu 24.04 L...
Join discussion
