Re: Proposal: Support Logical replication of large objects - Mailing list pgsql-hackers

From Nitin Motiani
Subject Re: Proposal: Support Logical replication of large objects
Date
Msg-id CAH5HC95-_D3enEzPaeN2r_6tmo8C0Zj4_m5=nvF=js8yvS+ayg@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: Support Logical replication of large objects  (Dilip Kumar <dilipbalaut@gmail.com>)
Responses Re: Proposal: Support Logical replication of large objects
List pgsql-hackers
Hi Dilip,

Thanks for initiating this work. I have created a POC for the apply
worker on top of your patch. I refactored lo_put to provide a function
which can be called without an fmgr and used that to apply the
lo_write operation coming from the publisher. I tested this manually
along with your patch and it works as long as lo_create is called
beforehand on the subscriber with the same oid. This patch currently
doesn't handle the tablesync worker so it can only apply the lo_write
ops done after the replication slot is created. I'm looking into how
to support large objects in tablesync. PFA the patch and let me know
what you think.

Thanks,
Nitin Motiani
Google

Attachment

pgsql-hackers by date:

Previous
From: VASUKI M
Date:
Subject: Re: [PATCH] psql: tab completion for ALTER ROLE ... IN DATABASE ...
Next
From: Andrey Borodin
Date:
Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)