HammerDB

NOVEMBER 22, 2021

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

Metrics Benchmarking C++ Database 62

Brendan Gregg

AUGUST 18, 2019

hardware Hardware counter-based instrumentation. The currently supported types are (more will be added): Type Description. tracepoint Kernel static instrumentation points. usdt User-level statically defined tracing. kprobe Kernel dynamic function instrumentation. kretprobe Kernel dynamic function return instrumentation.

Latency 68

Latency C++ Cache Programming 68

Percona

AUGUST 29, 2018

cat /proc/meminfo | grep -i huge AnonHugePages: 0 kB ShmemHugePages: 0 kB HugePages_Total: 88 HugePages_Free: 88 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB Now set the parameter huge_pages “on” in $PGDATA/postgresql.conf and restart the server. $

Tuning 55

Tuning Database Servers Processing 55

Percona

DECEMBER 27, 2022

This key is usually stored in a secure location, such as a hardware security module (HSM). To use public-key encryption with pgcrypto, you will need to generate a pair of keys using the pgp_gen_key function: SELECT * FROM pgp_gen_key('my_key', 'rsa', 2048, '', '', 'my@email.com'); This will generate a pair of keys and return them as a record.

Database 94

Database Storage Servers Strategy 94

Percona

AUGUST 29, 2023

Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. Now let’s stretch our imagination and consider a second method of high availability, ala Citus. The best way to describe the Citus way of doing things is to reflect how data is managed by a disk RAID array. citus_columnar | 11.1-1

C++ 78

C++ Database Storage Testing 78

SQL Server According to Bob

JANUARY 11, 2020

ReadFile WriteFile ReadFileScatter WriteFileGather GetOverlappedResult ​​ For extended details on the 823 error, see ​​ Error message 823 may indicate hardware problems or system problems ​​ ( [link] i crosoft.com/default.aspx?scid=kb ​​ Contact your hardware manufacture for assistance.

Servers 40

Servers Cache Database Media 40