article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

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++ 95
article thumbnail

HammerDB v4.3 New Features Pt1: Graphical Metrics for PostgreSQL

HammerDB

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 62
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Malfunctioning virus protection Heavy use of compression Network unresponsiveness Dual I/O path software malfunctions Microsoft SQL Server 2005 Enhancements The following section outlines the ​​ core ​​ I/O ​​ enhancements made in SQL Server 2005. For more information about DOD-5012.2

Servers 40