anarazel

SeaBIOS (version 1.8.2-google)
Total RAM Size = 0x0000000100000000 = 4096 MiB
CPUs found: 4     Max CPUs supported: 4
found virtio-scsi at 0:3
virtio-scsi vendor='Google' product='PersistentDisk' rev='1' type=0 removable=0
virtio-scsi blksize=512 sectors=48234496 = 23552 MiB
drive 0x000f2520: PCHS=0/0/0 translation=lba LCHS=1024/255/63 s=48234496
Sending Seabios boot VM event.
Booting from Hard Disk 0...
Loading /boot/loader.conf.local

anarazel

commit 9fe21de5134c4321667eb2aa03f3f3d0d0524ee7
Author: Andres Freund <andres@anarazel.de>
Date:   2020-12-28 11:46:36 -0800

    WIP: block: Allow disabling fua support via sysfs.

diff --git a/block/blk-flush.c b/block/blk-flush.c
index 76c1624cb06c..914f8748fa20 100644
--- a/block/blk-flush.c
+++ b/block/blk-flush.c

anarazel

SeaBIOS (version 1.8.2-google)
Total RAM Size = 0x0000000800000000 = 32768 MiB
CPUs found: 8     Max CPUs supported: 8
found virtio-scsi at 0:3
virtio-scsi vendor='Google' product='PersistentDisk' rev='1' type=0 removable=0
virtio-scsi blksize=512 sectors=419430400 = 204800 MiB
drive 0x000f2520: PCHS=0/0/0 translation=lba LCHS=1024/255/63 s=419430400
Sending Seabios boot VM event.
Booting from Hard Disk 0...
Malformed line (7):

anarazel

SeaBIOS (version 1.8.2-google)
Total RAM Size = 0x0000000800000000 = 32768 MiB
CPUs found: 8     Max CPUs supported: 8
found virtio-scsi at 0:3
virtio-scsi vendor='Google' product='PersistentDisk' rev='1' type=0 removable=0
virtio-scsi blksize=512 sectors=419430400 = 204800 MiB
drive 0x000f2520: PCHS=0/0/0 translation=lba LCHS=1024/255/63 s=419430400
Sending Seabios boot VM event.
Booting from Hard Disk 0...
Malformed line (7):

anarazel

No zone specified. Using zone [australia-southeast1-b] for instance: [fbsd-test-3].
SeaBIOS (version 1.8.2-google)
Total RAM Size = 0x0000000800000000 = 32768 MiB
CPUs found: 8     Max CPUs supported: 8
found virtio-scsi at 0:3
virtio-scsi vendor='Google' product='PersistentDisk' rev='1' type=0 removable=0
virtio-scsi blksize=512 sectors=268435456 = 131072 MiB
drive 0x000f2520: PCHS=0/0/0 translation=lba LCHS=1024/255/63 s=268435456
Sending Seabios boot VM event.
Booting from Hard Disk 0...

anarazel

SeaBIOS (version 1.8.2-google)
Total RAM Size = 0x00000000f0000000 = 3840 MiB
CPUs found: 1     Max CPUs supported: 1
found virtio-scsi at 0:3
virtio-scsi vendor='Google' product='PersistentDisk' rev='1' type=0 removable=0
virtio-scsi blksize=512 sectors=48234496 = 23552 MiB
drive 0x000f2320: PCHS=0/0/0 translation=lba LCHS=1024/255/63 s=48234496
Sending Seabios boot VM event.
Booting from Hard Disk 0...
Malformed line (7):

anarazel

5 seconds per test
O_DIRECT supported on this platform for open_datasync and open_sync.

Compare file sync methods using one 8kB write:
(in wal_sync_method preference order, except fdatasync is Linux's default)
        open_datasync                    522565.439 ops/sec       2 usecs/op
        fdatasync                                       n/a
        fsync                               221.680 ops/sec    4511 usecs/op
        fsync_writethrough                  244.217 ops/sec    4095 usecs/op
        open_sync                                       n/a

anarazel

#!/usr/bin/env python3

import os
import sys
import re
from csv_helper import csv
import collections
import datetime
import signal

anarazel

#include <pthread.h>
#include <stdio.h>
#include <stdint.h>
#include <unistd.h>
#include <signal.h>
#include <stdlib.h>
#include <string.h>

#define NTHREADS 40

anarazel

DROP VIEW IF EXISTS mem_raw;
CREATE VIEW mem_raw AS
    SELECT pid,
        (
            SELECT json_object_agg(m[1], m[2])
            FROM
                pg_read_file(format('/proc/%s/status', pid)) s(smaps),
                regexp_matches(smaps, '^([a-zA-Z][^:]+):\s+(.*)$', 'ng') m
        ) AS status_split
        ,(