Percona

DECEMBER 20, 2023

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. OS maintains a huge list of allocated and free pages to make slow but reliable address translation from virtual to physical. Huge pages make PostgreSQL faster; can we implement it in Kubernetes?

C++ 105

C++ Virtualization Benchmarking Database 105

HammerDB

SEPTEMBER 24, 2024

The key findings of the article were as follows: This server had a HammerDB benchmark running against it. But why are we running a COPY operation during a benchmark anyway? So this COPY statement is coming from the schema build phase and not the HammerDB benchmark workload at all. and start the build running.

Benchmarking 68

Benchmarking Performance Metrics Database 68

HammerDB

NOVEMBER 22, 2021

This enables the user to compare and contrast performance across different benchmark scenarios. shared_preload_libraries = 'pg_stat_statements,pgsentinel' track_activity_query_size=2048 pg_stat_statements.save=on pg_stat_statements.track=all pgsentinel_pgssh.enable = true pgsentinel_ash.pull_frequency = 1 pgsentinel_ash.max_entries = 1000000.

Metrics 63

Metrics Benchmarking C++ Database 63

SQL Server According to Bob

JANUARY 11, 2020

​​ The following table outlines the virtual protection states. Page State Virtual Protection State Dirty Read Write ​​ during the modification. Page State Virtual Protection State Dirty Read Write ​​ during the modification.

Servers 40

Servers Cache Database Media 40