On Mon, 22 Jan 2024 at 05:50, Chris Angelico <ros...@gmail.com> wrote: > > On Mon, 22 Jan 2024 at 05:25, Justin <zzzzz.g...@gmail.com> wrote: > > 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. > > I'll try dropping the table, creating it again with a PK, and seeing > how it goes. Thanks. >
Okay, it seems to be working now. Thanks! Hopefully that was the only issue. I'm a bit surprised by this, the docs do seem to imply that it ought to work (albeit inefficiently). Maybe I made it worse by initially creating the table without specifying the replica identity, and had to alter it in afterwards? ChrisA
