Hi Sergey, On Wed, 28 Feb 2024, Sergey Fukanchik wrote:
Hi Dimitrios, Do you have wal archiving enabled? $PGDATA/pg_wal/ is a bit different from tablespaces (including "default" one). It stores transaction journal.
I don't think I have WAL archiving enabled. Here are the relevant WAL options in my config: wal_compression = zstd max_wal_size = 8GB min_wal_size = 1GB track_wal_io_timing = on wal_writer_flush_after = 8MB The issue happens because the WAL directory is by default in the same filesystem with the default tablespace (root partition for Ubuntu). So when the default tablespace filled up because of my ALTER TABLE operation, there was no space for WAL either. Thanks, Dimitris
