From: | Kirill Reshke <reshkekirill(at)gmail(dot)com> |
---|---|
To: | "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Compression of bigger WAL records |
Date: | 2025-01-12 18:36:08 |
Message-ID: | CALdSSPiP2NgBo-41w4SGubBykZkk32HnDoZfsf6bVCcSfN5irQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I
./pgbin/bin/pg_waldump
On Sun, 12 Jan 2025 at 17:43, Andrey M. Borodin <x4mmm(at)yandex-team(dot)ru> wrote:
>
> Hi hackers!
>
> I propose a slight change to WAL compression: compress body of big records, if it's bigger than some threshold.
>
Hi,
initdb fails when configured with --without-zstd
```
reshke(at)ygp-jammy:~/postgres$ ./pgbin/bin/initdb -D db
The files belonging to this database system will be owned by user "reshke".
This user must also own the server process.
The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are enabled.
creating directory db ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default "max_connections" ... 100
selecting default "autovacuum_worker_slots" ... 16
selecting default "shared_buffers" ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... 2025-01-12 18:10:47.657 UTC [4167965]
FATAL: zstd is not supported by this build
2025-01-12 18:10:47.657 UTC [4167965] PANIC: cannot abort transaction
1, it was already committed
Aborted (core dumped)
child process exited with exit code 134
initdb: removing data directory "db"
```
Also pg_waldump fails with
```
corrupted size vs. prev_size
Aborted (core dumped)
```
Best regards,
Kirill Reshke
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Korotkov | 2025-01-12 18:39:03 | Re: POC, WIP: OR-clause support for indexes |
Previous Message | Michail Nikolaev | 2025-01-12 16:40:09 | Re: Strange assertion in procarray.c |