Remove 2018 Remove Benchmarking Remove Cache Remove Storage
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. Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database workload. This parameter sets how much dedicated memory will be used by PostgreSQL for the cache.

Tuning 52
article thumbnail

How to improve Redo, Transaction Log and WAL throughput for HammerDB benchmarks

HammerDB

This post at an entry-level discusses the options you have to improve log throughput in your benchmark environment. . To illustrate the data reads on Oracle we can flush the buffer cache. Consequently we now need to increase the buffer cache in size if we are to see more CPU activity. so what are your options? PostgreSQL.

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

Progress Delayed Is Progress Denied

Alex Russell

As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. With each team, benchmarks lost are understood as bugs. Chrome has missed several APIs for 3+ years: Storage Access API. Pointer Lock.

Media 145
article thumbnail

The Performance Inequality Gap, 2021

Alex Russell

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. India became a 4G-centric market sometime in 2018. The Moto G4 , for example. 2] Getting accurate global information that isn't artificially reduced to averages remains an ongoing challenge.

article thumbnail

Front-End Performance Checklist 2021

Smashing Magazine

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. This improves page load time and caching during navigations.

article thumbnail

Can You Afford It?: Real-world Web Performance Budgets

Alex Russell

Budgets are scaled to a benchmark network & device. Deciding what benchmark to use for a performance budget is crucial. Simulated packet loss and variable latency, however, can make benchmarking extremely difficult and slow. Time required to read bytes from disk (it’s not zero, even on flash-based storage!).

article thumbnail

Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]

Smashing Magazine

Globally in 2018–2019, according to the IDC, 87% of all shipped mobile phones are Android devices. Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. PRPL stands for Pushing critical resource, Rendering initial route, Pre-caching remaining routes and Lazy-loading remaining routes on demand.