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 evolution of single-core bandwidth in multicore processors

John McCalpin

Some I will address today, and some in the next blog entry. link] ) For the single-core case the bandwidth reported by the STREAM benchmark kernels is very close to the same as the bandwidth for the all-read tests reported here. Details in the next blog entry.) Stay tuned! Why not something like STREAM?

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

Percona Database Performance Blog 2018 Year in Review: Top Blog Posts

Percona

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

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. Some applications perform better by tuning a parameter and some don’t. wal_buffers. Conclusion.

Tuning 54
article thumbnail

How To Scale a Single-Host PostgreSQL Database With Citus

Percona

Leveraging pgbench , which is a benchmarking utility that comes bundled with PostgreSQL, I will put the cluster through its paces by executing a series of DML operations. And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database 102
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 133
article thumbnail

Dynatrace Application Security detects and blocks attacks automatically in real-time

Dynatrace

A perfect OWASP benchmark score for injection attacks – 100% accuracy and zero false positives – impressively proves the precision of our approach. We will further enhance the detection and blocking capability to cover additional attack types, so stay tuned for updates!

Traffic 233