Re: New Table Access Methods for Multi and Single Inserts - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: New Table Access Methods for Multi and Single Inserts
Date
Msg-id c54a69a8b60bae42499b86ff771ecbcdad29326d.camel@j-davis.com
Whole thread Raw
In response to Re: New Table Access Methods for Multi and Single Inserts  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Responses Re: New Table Access Methods for Multi and Single Inserts
List pgsql-hackers
> If we agree on removing heap_multi_insert_v2 API and embed that logic
> inside heap_insert_v2, then we can do this - pass the required
> information and the functions ExecInsertIndexTuples and
> ExecARInsertTriggers as callbacks so that, whether or not
> heap_insert_v2 choses single or multi inserts, it can callback these
> functions with the required information passed after the flush. We
> can
> add the callback and required information into TableInsertState. But,
> I'm not quite sure, we would make ExecInsertIndexTuples and
> ExecARInsertTriggers.

How should the API interact with INSERT INTO ... SELECT? Right now it
doesn't appear to be integrated at all, but that seems like a fairly
important path for bulk inserts.

Regards,
    Jeff Davis





pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Is Recovery actually paused?
Next
From: Justin Pryzby
Date:
Subject: Re: PoC/WIP: Extended statistics on expressions