article thumbnail

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

PostgreSQL performance optimization aims to improve the efficiency of a PostgreSQL database system by adjusting configurations and implementing best practices to identify and resolve bottlenecks, improve query speed, and maximize database throughput and responsiveness. Why is PostgreSQL performance tuning important?

Tuning 52
article thumbnail

How we achieved 5X faster pipeline execution by removing closure allocations

Particular Software

The less Gen 0 allocation used, the more speed can be squeezed out of the message handling pipeline, which ultimately means more speed for our users. With this simple change, we’ve seen 5 times more throughput in the raw pipeline execution benchmarks and all allocations that previously occurred due to closures are gone. ??

Lambda 98
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

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

Enhanced User Experience Whether you operate an e-commerce platform, a content management system, or any other application reliant on MySQL, users will notice and appreciate the improved speed and responsiveness. It is a good idea to run sysbench or another benchmark tool to determine your storage throughput.

Tuning 52
article thumbnail

Real user monitoring vs. synthetic monitoring: Understanding best practices

Dynatrace

Data collected on page load events, for example, can include navigation start (when performance begins to be measured), request start (right before the user makes a request from the server), and speed index metrics (measure page load speed). In some cases, you will lack benchmarking capabilities. Watch webinar now!

article thumbnail

RPC vs. Messaging – which is faster?

Particular Software

Sometimes developers only care about speed. Why RPC is “faster” It’s tempting to simply write a micro-benchmark test where we issue 1000 requests to a server over HTTP and then repeat the same test with asynchronous messages. But that’s just a micro-benchmark and doesn’t tell you the whole story. Messaging doesn’t do that.

article thumbnail

The Ultimate Guide to MySQL Partitions

Percona

Watch this on-demand webinar from Percona to learn how! Each partition holds data that falls within a specific range, optimizing data handling and query speed. This version also notably integrates native backing for range and list partitioning of spatial indexes, amplifying geospatial query speed for substantial datasets.