article thumbnail

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

This blog was originally published in August 2018 and was updated in May 2023. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload.

Tuning 52
article thumbnail

The Most Important MySQL Setting

Percona

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? To be fair, that is also true with PostgreSQL; it hasn’t been tuned either, and it, too, can also perform much better.

Tuning 134
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Crucial Redis Monitoring Metrics You Must Watch

Scalegrid

This blog post lists the important database metrics to monitor. Effective management of memory stores with policies like LRU/LFU proactive monitoring of the replication process and advanced metrics such as cache hit ratio and persistence indicators are crucial for ensuring data integrity and optimizing Redis’s performance.

Metrics 130
article thumbnail

Migrating Critical Traffic At Scale with No Downtime?—?Part 1

The Netflix TechBlog

Migrating Critical Traffic At Scale with No Downtime — Part 1 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Hundreds of millions of customers tune into Netflix every day, expecting an uninterrupted and immersive streaming experience. It helps expose memory leaks, deadlocks, caching issues, and other system issues.

Traffic 339
article thumbnail

Migrating Netflix to GraphQL Safely

The Netflix TechBlog

This blog post will share broadly-applicable techniques (beyond GraphQL) we used to perform this migration. And we definitely couldn’t replay test non-functional requirements like caching and logging user interaction. This blog post is part of our Migrating Critical Traffic series. To launch Phase 1 safely, we used AB Testing.

Traffic 353
article thumbnail

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Scalegrid

In this blog post, we’ll explain how PgBouncer works, the pros and cons of using it, and how to setup the connection pooler. Once the authentication succeeds: PgBouncer checks for a cached connection, with the same username+database combination. If a cached connection is found, it returns the connection to the client.

Cache 246
article thumbnail

Tuning PostgreSQL Database Parameters to Optimize Performance

Percona

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. This parameter sets how much dedicated memory will be used by PostgreSQL for cache. wal_buffers.

Tuning 54