article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

It’s easy with anydbver and k3d. git clone [link] cd anydbver ansible-galaxy collection install theredgreek.sqlite echo PROVIDER=docker > anydbver (cd images-build; /build.sh) Start k3d cluster and install Percona Operator for PostgreSQL 2.2.0: /anydbver deploy k8s-pg:2.2.0

C++ 97
article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

Installation is easy with the software comes in popular package formats. Percona Toolkit may already be in your distro by default in many Linux distros, such as Fedora, Homebrew, and Debian. And you can get it from us at Percona. autovacuum_vacuum_insert_threshold : 1000 autovacuum_vacuum_scale_factor : 0.2

Cache 98
Insiders

Sign Up for our Newsletter

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

Trending Sources

article thumbnail

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

HammerDB

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. ./ -I/opt/postgresql-14.1/include/server include/server -I/opt/postgresql-14.1/include/internal

Metrics 62
article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

bpftrace is a new open source tracer for Linux for analyzing production performance problems and troubleshooting software. software Kernel software-based events. However, the functions it exposes are not considered a stable API, as they can change from one software version to another.

Latency 68
article thumbnail

SQL Server on Linux: Scatter/Gather == Vectored I/O

SQL Server According to Bob

On Linux the total number of buffers that can be read or written, in a single ABI request, is capped at 2048. Within LibOS, when we detect a request exceeding 2048 OS pages, we split the request into multiple 2048 page chunks, deemed sub-I/O requests. Bob Dorr – Principal Software Engineer SQL Server.

Servers 40
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