Remove c
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++ 103
article thumbnail

Poor Disk Performance

Brendan Gregg

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.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Data Redundancy With the PostgreSQL Citus Extension

Percona

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

Configuring PostgreSQL and LDAP Using StartTLS

Percona

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

Poor Disk Performance

Brendan Gregg

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.

article thumbnail

Poor Disk Performance

Brendan Gregg

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.

article thumbnail

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

HammerDB

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 62