Skip to content

Instantly share code, notes, and snippets.

View anarazel's full-sized avatar

Andres Freund anarazel

421 followers · 0 following
View GitHub Profile
@anarazel
anarazel / summary.txt
Created August 23, 2022 16:57
summary:
- postgresql 16devel Data layout
data block size: 8192
WAL block size: 8192
segment size: 131072
System
host system: 'linux x86_64'
build system: 'linux x86_64'
Compiler
linker: 'ld.bfd'
@anarazel
anarazel / test.sql
Created August 4, 2022 21:04
DROP TABLE IF EXISTS test_io_strategy;
SELECT sum(alloc) AS io_sum_strategy_allocs_before FROM pg_stat_io WHERE io_context = 'Strategy' \gset
SELECT sum(read) AS io_sum_strategy_reads_before FROM pg_stat_io WHERE io_context = 'Strategy' \gset
CREATE TABLE test_io_strategy(a INT, b INT);
ALTER TABLE test_io_strategy SET (autovacuum_enabled = 'false');
INSERT INTO test_io_strategy SELECT i, i from generate_series(1, 8000)i;
-- Ensure that the next VACUUM will need to perform IO by rewriting the table
-- first with VACUUM (FULL).
SELECT relforknumber, count(*) AS bufcount FROM pg_buffercache WHERE relfilenode = (SELECT relfilenode FROM pg_class WHERE oid = 'test_io_strategy'::regclass) GROUP BY relforknumber;
@anarazel
anarazel / gist:d14e581abe4e29f839a03f0e56db6ee7
Created August 1, 2022 19:57
/home/andres/src/postgresql/meson.build:2390:4: warning empty if statement block
2390 | if host_system == 'win32'
^
dbg executing /usr/bin/gcc-12: 'gcc-12' '--version'
detected compiler gcc 12.1.0 (gcc-12), linker ld.bfd
dbg executing /usr/bin/gcc-12: 'gcc-12' '--print-search-dirs'
configuring 'postgresql', version: 16devel
dependency threads found
found dependency threads
dbg executing /usr/bin/bison: '/usr/bin/bison' '--version'
@anarazel
anarazel / gist:293379f653d9c166c833be13e5496344
Created August 1, 2022 19:56
/home/andres/src/postgresql/meson.build:2390:4: warning empty if statement block
2390 | if host_system == 'win32'
^
dbg executing /usr/bin/gcc-12: 'gcc-12' '--version'
detected compiler gcc 12.1.0 (gcc-12), linker ld.bfd
dbg executing /usr/bin/gcc-12: 'gcc-12' '--print-search-dirs'
configuring 'postgresql', version: 16devel
dependency threads found
found dependency threads
dbg executing /usr/bin/bison: '/usr/bin/bison' '--version'
@anarazel
anarazel / gist:2d8d9098256d83a45790a9bad0190b74
Created July 28, 2022 10:37
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=52428800 = 25600 MiB
drive 0x000f2940: PCHS=0/0/0 translation=lba LCHS=1024/255/63 s=52428800
Sending Seabios boot VM event.
Booting from Hard Disk 0...
Loading /boot/loader.conf.local
@anarazel
anarazel / gist:e9a9c8eeb13ab62872ef5a5c0b8ccf05
Last active April 12, 2022 17:49
ServerLoop+4463; PostgresMain+7469; PortalRun+652; PortalRunMulti+531; pgss_ExecutorRun+254; standard_ExecutorRun+269; ExecModifyTable+777; ExecUpdate+835; heapam_tuple_lock+492; XactLockTableWait+173; TransactionIdIsInProgress+157; LWLockAcquire+702 759
__libc_start_main+205; main+543; PostmasterMain+3403; ServerLoop+4463; PostgresMain+7469; PortalRun+652; PortalRunMulti+531; pgss_ExecutorRun+254; standard_ExecutorRun+269; ExecModifyTable+777; ExecUpdate+835; heapam_tuple_lock+352; heap_fetch+256; HeapTupleSatisfiesVisibility+3163; TransactionIdIsInProgress+157; LWLockAcquire+702 773
__libc_start_main+205; main+543; PostmasterMain+3403; ServerLoop+4463; PostgresMain+7469; PortalRun+652; PortalRunMulti+531; pgss_ExecutorRun+254; standard_ExecutorRun+269; ExecModifyTable+777; ExecUpdate+835; heapam_tuple_lock+492; XactLockTableWait+173; TransactionIdIsInProgress+157; LWLockAcquire
@anarazel
anarazel / gist:be1d9cd65ffa4ccfcb12e8c5421a9c8f
Created October 6, 2021 09:02
This file has been truncated, but you can view the full file.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<base href="https://buildfarm.postgresql.org/" />
<title>PostgreSQL BuildFarm Status</title>
<link rel="icon" type="image/png" href="/elephant-icon.png" />
<link rel="stylesheet" rev="stylesheet" href="/inc/pgbf.css" charset="utf-8" />
<style type="text/css"><!--
@anarazel
anarazel / gist:5df8b865aebe341259a222355aadd968
Created October 6, 2021 08:19
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<base href="https://buildfarm.postgresql.org/" />
<title>PostgreSQL BuildFarm Status</title>
<link rel="icon" type="image/png" href="/elephant-icon.png" />
<link rel="stylesheet" rev="stylesheet" href="/inc/pgbf.css" charset="utf-8" />
<style type="text/css"><!--
@anarazel
anarazel / gist:18bc805c6122e22dd870942e17f00330
Last active October 6, 2021 09:01
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<base href="https://buildfarm.postgresql.org/" />
<title>PostgreSQL BuildFarm Status</title>
<link rel="icon" type="image/png" href="/elephant-icon.png" />
<link rel="stylesheet" rev="stylesheet" href="/inc/pgbf.css" charset="utf-8" />
<style type="text/css"><!--
@anarazel
anarazel / gist:24cb1d2b46bb87d221ab4e8761b4d49f
Created September 29, 2021 00:33
diff -w -U3 C:/Users/anfreund/src/pg-meson/src/test/regress/expected/float4.out C:/Users/anfreund/src/pg-meson/build-ninja-x64/testrun/main/pg_regress/results/float4.out
--- C:/Users/anfreund/src/pg-meson/src/test/regress/expected/float4.out 2021-09-10 15:40:30.356706400 -0700
+++ C:/Users/anfreund/src/pg-meson/build-ninja-x64/testrun/main/pg_regress/results/float4.out 2021-09-28 17:30:24.193373400 -0700
@@ -372,7 +372,7 @@
SELECT float4send('7038531e-32'::float4);
float4send
------------
- \x15ae43fd
+ \x15ae43fe
(1 row)