Hi, Commit 89e46da5e5 allowed us to use indexes for searching on REPLICA IDENTITY FULL tables. The documentation explains:
When replica identity <quote>full</quote> is specified, indexes can be used on the subscriber side for searching the rows. Candidate indexes must be btree, non-partial, and have at least one column reference (i.e. cannot consist of only expressions). To be exact, IIUC the column reference must be on the leftmost column of indexes. Does it make sense to mention that? I've attached the patch. Regards, -- Masahiko Sawada Amazon Web Services: https://aws.amazon.com
doc_update.patch
Description: Binary data