Horton

Re: [POC] Fast COPY FROM command for the table with foreign partitions

Andrei Lepikhov <a.lepikhov@postgrespro.ru>

View thread View on postgr.es
From: "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>
To: Amit Langote <amitlangote09@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>, Ashutosh Bapat <ashutosh.bapat@2ndquadrant.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Etsuro Fujita <etsuro.fujita@gmail.com>, PostgreSQL-Dev <pgsql-hackers@postgresql.org>
Date: 2020-09-08T10:21:33Z
Lists: pgsql-hackers 
On 9/8/20 12:34 PM, Amit Langote wrote:
> Hi Andrey,
> 
> On Mon, Sep 7, 2020 at 7:31 PM Andrey V. Lepikhov
> <a.lepikhov@postgrespro.ru> wrote:
>> On 9/7/20 12:26 PM, Michael Paquier wrote:
>>> While on it, the CF bot is telling that the documentation of the patch
>>> fails to compile.  This needs to be fixed.
>>> --
>>> Michael
>>>
>> v.7 (in attachment) fixes this problem.
>> I also accepted Amit's suggestion to rename all fdwapi routines such as
>> ForeignCopyIn to *ForeignCopy.
> 
> Any thoughts on the taking out the refactoring changes out of the main
> patch as I suggested?
> 
Sorry I thought you asked to ignore your previous letter. I'll look into 
this patch set shortly.

-- 
regards,
Andrey Lepikhov
Postgres Professional

Commits

  1. Allow batch insertion during COPY into a foreign table.

  2. postgres_fdw: Disable batch insertion when there are WCO constraints.

  3. Enforce foreign key correctly during cross-partition updates

  4. Fix permission checks on constraint violation errors on partitions.

  5. Fix compilation of uuid-ossp