Write Logical Replication Spill Files to different volume

From: Klaus Darilion <klaus(dot)mailinglists(at)pernau(dot)at>
To: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Write Logical Replication Spill Files to different volume
Date: 2024-01-30 13:08:09
Message-ID: ccaeb39db549003abec2d1a626404d4f@pernau.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

If I understand it right, the logical replication .spill files in the
pg_replslot subfolders are temporary files that need not survive server
crashes (as on postgresql restart the WAL senders will delete old spill
files, start again reading WAL and regenerate the spill files if
necessary).

For big transactions with plenty of replication slots, the spill files
may consume plenty of disk space. I think it would be useful to have the
spill files on a different disk, ie the "normal" database files and the
pg_replslot status file are on a high available volume (DRBD, shared
storage ...) whereas the spill files are only on local disks.

Is this already possible? If not, are there reasons why that should not
be done?

thanks
Klaus

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Kacsir 2024-01-30 13:54:10 Re: Good overview of programming IN Postgres?
Previous Message Shaheed Haque 2024-01-30 11:32:37 Re: Scriptable way to validate a pg_dump restore ?