Remove c
article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

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

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

HammerDB

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. include/internal -D_GNU_SOURCE -c -o pgsentinel.o /src/port -L././src/common lib',--enable-new-dtags -lm./postgresql-14.1/contrib/pg_stat_statements$

Metrics 62
Insiders

Sign Up for our Newsletter

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

article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

virtual = 2.2G virtual = 2.2G 2004l# Percona Toolkit System Summary Report ###################### Date | 2023-09-25 14:43:34 UTC (local TZ: CDT -0500) Hostname | testbox Uptime | 44 min, 1 user, load average: 0.47, 0.67, 0.57 Platform | Linux Release | Ubuntu 22.04.3 LTS (jammy) Kernel | 6.2.0-33-generic Shared | 475.0M Buffers | 3.8G

Cache 104
article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. Hit Ctrl-C to end. ^C Attaching 2 probes. ^C 1 /* 2 * biolatency.bt Attaching 3 probes.

Latency 57
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Character POS ASCII Value Formula Value A 1 65 67 C 2 67 69 Checksum 136 Comparing ​​ the checksum values indicates ​​ that the values do not match and ​​ damage ​​ has occurred to the data. ​​ The following table outlines the virtual protection states.

Servers 40