On Tue, Apr 5, 2022 at 10:10 AM Andy Fan <zhihui.fan1...@gmail.com> wrote: >> > I wanted to have a WAL record spanning multiple WAL files of size, say >> > 16MB. I'm wondering if the Full Page Images (FPIs) of a TOAST table >> > would help here. Please let me know if there's any way to generate >> > such large WAL records. >> >> It's easier to use pg_logical_emit_message(). > > Not sure I understand the question correctly here. What if I use the below > code > where the len might be very large? like 64MB. > > XLogBeginInsert(); > XLogRegisterData((char *)&xl_append, sizeof(xl_cstore_append)); > XLogRegisterData((char *)data, len); > > XLogInsert(..);
Well, that's how to do it from C. And pg_logical_emit_message() is how to do it from SQL. -- Robert Haas EDB: http://www.enterprisedb.com
