On Mon, 22 Jan 2024 at 05:25, Justin <zzzzz.graf@xxxxxxxxx> wrote: > > When using replica set to full this kicks off a full table scan for each update or delete this is very expensive. If there are no errors being reported you will find it is working but hung doing full scans. Inserts are just appended to end of heap. > That shouldn't be too costly, since this table only has a single row in it. But it never finishes the replication at all. > > You can copy the replication slot on the primary to peak at which transactions LR is hung on to confirm. > > Adding a primary key will fix this issue. Note PG 16 can use indexes to find qualifying rows when a table's replica is set to full. Ah, sadly PG 16 isn't an option as yet. It would definitely make dual-master replication somewhat easier. I'll try dropping the table, creating it again with a PK, and seeing how it goes. Thanks. ChrisA
