---
title: "#tuning articles | Hashnode"
description: "Explore 22 articles tagged #tuning on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/tuning"
---

Tag

# #tuning

22 posts · 0 followers

[Philip McClarence](https://hashnode.com/@pgdba) · [Apr 22](https://hashnode.com/posts/postgresql-parallel-query-configuration-performance-tuning/69e89c23a988bc74e89f1548)

### [PostgreSQL Parallel Query: Configuration & Performance Tuning](https://postgresdba.hashnode.dev/postgresql-parallel-query-configuration-performance-tuning?utm_source=hashnode&utm_medium=feed)

A practical guide for PostgreSQL and TimescaleDB

4 min read · [postgresdba.hashnode.dev](https://postgresdba.hashnode.dev/postgresql-parallel-query-configuration-performance-tuning?utm_source=hashnode&utm_medium=feed)

[Nishant Bhandari](https://hashnode.com/@nishant4532) · [Mar 14](https://hashnode.com/posts/memory-leak-vs-high-memory-usage-in-java-a-practical-explanation/69b59f0a210c74252f133a88)

### [Memory Leak vs High Memory Usage in Java — A Practical Explanation](https://java-insights.hashnode.dev/memory-leak-vs-high-memory-usage-in-java-a-practical-explanation?utm_source=hashnode&utm_medium=feed)

Stop confusing workload spikes with bugs. Learn the key differences between high memory usage and memory leaks in Java, how to read GC patterns, and t

4 min read · [java-insights.hashnode.dev](https://java-insights.hashnode.dev/memory-leak-vs-high-memory-usage-in-java-a-practical-explanation?utm_source=hashnode&utm_medium=feed)

[Philip McClarence](https://hashnode.com/@pgdba) · [Mar 10](https://hashnode.com/posts/timescaledb-memory-tuning-sharedbuffers-workmem-and-chunk-sizing/69afeba3fbcdb0cc1aebe31f)

### [TimescaleDB Memory Tuning: shared\_buffers, work\_mem, and Chunk Sizing](https://postgresdba.hashnode.dev/timescaledb-memory-tuning-sharedbuffers-workmem-and-chunk-sizing?utm_source=hashnode&utm_medium=feed)

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 --...

5 min read · [postgresdba.hashnode.dev](https://postgresdba.hashnode.dev/timescaledb-memory-tuning-sharedbuffers-workmem-and-chunk-sizing?utm_source=hashnode&utm_medium=feed)

[Philip McClarence](https://hashnode.com/@pgdba) · [Mar 9](https://hashnode.com/posts/postgresql-performance-tuning-the-complete-configuration-guide/69ae9a221c6c68225c5cec48)

### [PostgreSQL Performance Tuning: The Complete Configuration Guide](https://postgresdba.hashnode.dev/postgresql-performance-tuning-the-complete-configuration-guide?utm_source=hashnode&utm_medium=feed)

A practical guide for PostgreSQL and TimescaleDB

15 min read · [postgresdba.hashnode.dev](https://postgresdba.hashnode.dev/postgresql-performance-tuning-the-complete-configuration-guide?utm_source=hashnode&utm_medium=feed)

[Philip McClarence](https://hashnode.com/@pgdba) · [Mar 6](https://hashnode.com/posts/tuning-pgvector-queries-probes-efsearch-and-distance-functions/69aaa5a1fb6f3a617bf21ab4)

### [Tuning pgvector Queries: Probes, ef\_search, and Distance Functions](https://postgresdba.hashnode.dev/tuning-pgvector-queries-probes-efsearch-and-distance-functions?utm_source=hashnode&utm_medium=feed)

A practical guide for PostgreSQL and TimescaleDB

5 min read · [postgresdba.hashnode.dev](https://postgresdba.hashnode.dev/tuning-pgvector-queries-probes-efsearch-and-distance-functions?utm_source=hashnode&utm_medium=feed)

[IAMDevBox](https://hashnode.com/@IAMDevBox) · [Mar 2](https://hashnode.com/posts/optimizing-pingdirectory-for-enterprise-scale-performance/69a5c0add5dbe6cbab75d873)

### [Optimizing PingDirectory for Enterprise Scale Performance](https://iamdevbox.hashnode.dev/optimizing-pingdirectory-for-enterprise-scale-performance?utm_source=hashnode&utm_medium=feed)

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...

4 min read · [iamdevbox.hashnode.dev](https://iamdevbox.hashnode.dev/optimizing-pingdirectory-for-enterprise-scale-performance?utm_source=hashnode&utm_medium=feed)

[Philip McClarence](https://hashnode.com/@pgdba) · [Feb 26](https://hashnode.com/posts/postgresql-autovacuum-tuning-a-practical-guide-1/69a0373545a70e5259cf9600)

### [PostgreSQL Autovacuum Tuning: A Practical Guide](https://postgresdba.hashnode.dev/postgresql-autovacuum-tuning-a-practical-guide-1?utm_source=hashnode&utm_medium=feed)

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 ...

6 min read · [postgresdba.hashnode.dev](https://postgresdba.hashnode.dev/postgresql-autovacuum-tuning-a-practical-guide-1?utm_source=hashnode&utm_medium=feed)

[SQL Server Expert](https://hashnode.com/@sqlserver-expert) · [Aug 14, 2025](https://hashnode.com/posts/entendendo-wait-types-no-sql-server-um-guia-para-iniciantes/689d513cc5b5386ef5fa7ad1)

### [Entendendo Wait Types no SQL Server: um guia para iniciantes](https://sqlserver-expert.hashnode.dev/entendendo-wait-types-no-sql-server-um-guia-para-iniciantes?utm_source=hashnode&utm_medium=feed)

Aprenda a ler waits no SQL Server, identificar gargalos (CPU, I/O, bloqueios) e priorizar ações de performance com sys.dm\_os\_wait\_stats.

4 min read · [sqlserver-expert.hashnode.dev](https://sqlserver-expert.hashnode.dev/entendendo-wait-types-no-sql-server-um-guia-para-iniciantes?utm_source=hashnode&utm_medium=feed)

[SQL Server Expert](https://hashnode.com/@sqlserver-expert) · [Aug 4, 2025](https://hashnode.com/posts/triggers-no-sql-server-conceitos-tipos-e-impacto-no-desempenho/68912499b060b9a86ae95549)

### [Triggers no SQL Server: Conceitos, Tipos e Impacto no Desempenho](https://sqlserver-expert.hashnode.dev/triggers-no-sql-server-conceitos-tipos-e-impacto-no-desempenho?utm_source=hashnode&utm_medium=feed)

Veja como triggers afetam o desempenho do SQL Server e como evitar armadilhas como cursores e recursividade.

17 min read · [sqlserver-expert.hashnode.dev](https://sqlserver-expert.hashnode.dev/triggers-no-sql-server-conceitos-tipos-e-impacto-no-desempenho?utm_source=hashnode&utm_medium=feed)

[Chitt Ranjan Mahto (Chirag)](https://hashnode.com/@chittrmahto) · [Jul 20, 2025](https://hashnode.com/posts/installation-configuration-and-tuning-of-postgresql-17-and-pgadmin4-in-ubuntu-2404-lts/687c506b8e3a94c8e3d53c04)

### [Installation, Configuration & Tuning of PostgreSQL 17 and pgAdmin4 in Ubuntu 24.04 LTS](https://chiragtutorial.hashnode.dev/installation-configuration-and-tuning-of-postgresql-17-and-pgadmin4-in-ubuntu-2404-lts?utm_source=hashnode&utm_medium=feed)

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...

4 min read · [chiragtutorial.hashnode.dev](https://chiragtutorial.hashnode.dev/installation-configuration-and-tuning-of-postgresql-17-and-pgadmin4-in-ubuntu-2404-lts?utm_source=hashnode&utm_medium=feed)
