mjf

Online rename interface with Systemd Networkd

1. create .link file in for the interface to rename it to a name of choice:

   [Match]
   OriginalName=*
   MACAddress=<mac-address>
   

[Link]

mjf

Zimbra 9.0.0 GA 4325 Patch 28-32 Bugfixes

cat /etc/os-release

NAME="Rocky Linux"
VERSION="8.7 (Green Obsidian)"

mjf

Reclaiming space from bloated table without enough space left

The vacuum full needs two-times the table size to perform on it because it first makes full physical copy of the table. If you are running out of space and in need of reclaiming the space occupated by dead tuples from a bloated database table but you can not because of lacking free space in the table's namespace here is how you can work around that (assuming you some additional disk space resources can be added to the server). It is also the least disruptive method of doing it (in comparison to the obvious dump and restore et cetera).

mjf

Year	List	Subject:	Version
2017	pgsql-hackers	VACUUM and ANALYZE disagreeing on what reltuples means	<= 10

mjf

Personal

• Niko Matsakis - excellent and must read articles (!)

mjf

3x run?! One rights after another?!

zimbra@zimbra:~$ zmprov modifyConfig zimbraMtaMaxMessageSize 1073741824
/opt/zimbra/bin/zmjava: line 59: /bin/java: No such file or directory
zimbra@zimbra:~$ zmprov modifyConfig zimbraMtaMaxMessageSize 1073741824
Killed
zimbra@zimbra:~$ zmprov modifyConfig zimbraMtaMaxMessageSize 1073741824

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