Skip to content

Instantly share code, notes, and snippets.

View anarazel's full-sized avatar

Andres Freund anarazel

View GitHub Profile
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
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
/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'
/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'
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;
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'
/home/andres/src/postgresql/meson.build:403:6: warning empty if statement block
403 | if not have_gssapi
^
/home/andres/src/postgresql/meson.build:412:6: warning empty if statement block
412 | if not have_gssapi
^
/home/andres/src/postgresql/meson.build:2348:4: warning empty if statement block
2348 | if host_system == 'win32'
^
dbg executing /usr/bin/ccache: 'ccache' '--version'
/home/andres/src/postgresql/meson.build:403:6: warning empty if statement block
403 | if not have_gssapi
^
/home/andres/src/postgresql/meson.build:412:6: warning empty if statement block
412 | if not have_gssapi
^
/home/andres/src/postgresql/meson.build:2348:4: warning empty if statement block
2348 | if host_system == 'win32'
^
dbg executing /usr/bin/ccache: 'ccache' '--version'
/home/andres/src/postgresql/meson.build:403:6: warning empty if statement block
403 | if not have_gssapi
^
/home/andres/src/postgresql/meson.build:412:6: warning empty if statement block
412 | if not have_gssapi
^
/home/andres/src/postgresql/meson.build:2349:4: warning empty if statement block
2349 | if host_system == 'win32'
^
dbg executing /usr/bin/ccache: 'ccache' 'gcc-12' '--version'
#!/bin/bash
set -e
DIR=~/build/llvm-project/master/debug-clang
mkdir -p $DIR/vpath
cd $DIR/vpath
#export LDFLAGS='-Wl,--compress-debug-sections=zlib -fuse-ld=lld '
cmake \