Percona

DECEMBER 20, 2023

Unfortunately, the performance in benchmarks is almost the same as for 4KB pages. Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information. Setup I recommend starting with 2MB huge pages because it’s trivial to set up. It’s easy with anydbver and k3d.

C++ 120

C++ Virtualization Benchmarking Database 120

Brendan Gregg

MAY 8, 2021

People often tell me they don't understand performance tool output because they can't tell what's "good" or "bad." It can be hard as performance is subjective. I recently encountered terrible disk performance and thought it'd be useful to collect Linux tool screenshots and share them for reference. Hit Ctrl-C to end.

Performance 133

Performance Latency Speed Systems 133

Percona

AUGUST 21, 2023

Even though there is an encrypted session between psql and the Postgres server, there is no encrypted session between Postgres and LDAP as authentication is performed: SSL connection (protocol: TLSv1.3,

C++ 98

C++ Servers Open Source Testing 98

Percona

AUGUST 29, 2023

Reference tables can be replicated to all nodes for joins and foreign keys from distributed tables and for maximum read performance. Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. The same can be said for Citus data sharding. The colors indicate duplicated shards of the table.

C++ 98

C++ Database Storage Testing 98

HammerDB

NOVEMBER 22, 2021

Introducing the PostgreSQL performance metrics viewer. HammerDB included a graphical performance metrics view for the Oracle database only. This enables the user to compare and contrast performance across different benchmark scenarios. usr/bin/install -c -m 644./pg_stat_statements--1.4.sql./pg_stat_statements--1.8--1.9.sql./pg_stat_statements--1.7--1.8.sql./pg_stat_statements--1.6--1.7.sql./pg_stat_statements--1.5--1.6.sql./pg_stat_statements--1.4--1.5.sql.

Metrics 63

Metrics Benchmarking C++ Database 63

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually.

Cache 114

Cache Database Virtualization Servers 114

Brendan Gregg

MAY 8, 2021

People often tell me they don't understand performance tool output because they can't tell what's "good" or "bad." It can be hard as performance is subjective. I recently encountered terrible disk performance and thought it'd be useful to collect Linux tool screenshots and share them for reference. Hit Ctrl-C to end.

Performance 40

Performance Latency Speed Systems 40