mjf

set background=dark

hi clear
if exists('syntax_on')
 syntax reset
endif

let g:colors_name = 'phoenix'

hi Normal ctermfg=250

mjf

                       Example Calculation
+------------------------------------------+--------------------+
|                          key_buffer_size |          16.000 MB |
|                         query_cache_size |          16.000 MB |
|                  innodb_buffer_pool_size |          64.000 MB |
|          innodb_additional_mem_pool_size |           8.000 MB |
|                   innodb_log_buffer_size |           8.000 MB |
+------------------------------------------+--------------------+
|                              BASE MEMORY |         112.000 MB |

mjf

# TODO: store just basename of the logfiles (in Starlark may be easy)
# TODO: include more information in tags (at least user_name and application_name?)

#
# INPUTS
#
[[inputs.tail]]

    name_override = "postgres_sql_state_code"

mjf

Postgres random articles

Syntax

• SQL Style Guide

PM and DR

• Transaction ID Wraparound in Postgres

Scaling

mjf

# Telegraf configuration to collect per-CPU cycles and instructions
# using perf(1).  You can then calculate CPI / IPC from the metrics.

# If Telegraf is not running as UID 0 (aka "root") you can either use
# sudo(1) with the perf(1) command, raise Telegraf capability, or set
# kernel.perf_event_paranoid = 0.  But be warned: "Hic sunt dracones".

[[inputs.exec]]

  name_prefix = "cpu_"

mjf

# Telegraf configuration to collect Pressure Stall Information (PSI)

[[inputs.file]]
  name_override = "pressure_cpu"
  # interval = "5s"
  files = ["/proc/pressure/cpu"]
  data_format = "grok"
  grok_patterns = [
    "%{NOTSPACE:type:tag} avg10=%{NUMBER:avg10:float} avg60=%{NUMBER:avg60:float} avg300=%{NUMBER:avg300:float} total=%{NUMBER:total:int}"
  ]

mjf

#! /bin/sh

# Encode and decode Crockford's BASE32
# Copyright (C) 2022 Matous Jan Fialka, <https://mjf.cz/>
# Released under the terms of the "MIT" license

# DO NOT USE FOR ANY REASON! This was just for some quick testing.

use() {
	printf -- '%s -d <enc> | <dec>\n' "${0##*/}"

mjf

with
  /* first generate random metric serie for past 1 day, 360 per hour */
  series as
  (
    select
      cast(
        now() - '1 day'::interval + n*'10 seconds'::interval
        as timestamp with time zone
      ),
      n*random()::double precision

mjf

Postgres blogs

(Persons are alphabeticaly sorted by family name, the rest is sorted by name.)

Personal

• Mark Andruth
• Lætitia Avrot
• Haki Benita
• Josh Berkus

mjf

set background=dark

hi clear
if exists('syntax_on')
 syntax reset
endif

let g:colors_name = 'mjf'

hi Normal ctermfg=250