Re: Custom table AMs need to include heapam.h because of BulkInsertState
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: David Rowley <david.rowley@2ndquadrant.com>
Cc: Andres Freund <andres@anarazel.de>, Robert Haas <robertmhaas@gmail.com>, Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2019-06-24T10:16:16Z
Lists: pgsql-hackers
On Sat, Jun 15, 2019 at 12:25:12PM +1200, David Rowley wrote: > With the attached version I'm just calling table_finish_bulk_insert() > once per partition at the end of CopyFrom(). We've got an array with > all the ResultRelInfos we touched in the proute, so it's mostly a > matter of looping over that array and calling the function on each > ResultRelInfo's ri_RelationDesc. However, to make it more complex, > PartitionTupleRouting is private to execPartition.c so we can't do > this directly... After staring at my screen for a while, I decided to > write a function that calls a callback function on each ResultRelInfo > in the PartitionTupleRouting. Don't take me bad, but I find the solution of defining and using a new callback to call the table AM callback not really elegant, and keeping all table AM callbacks called at a higher level than the executor makes the code easier to follow. Shouldn't we try to keep any calls to table_finish_bulk_insert() within copy.c for each partition instead? > The other thing I noticed is that we call > table_finish_bulk_insert(cstate->rel, ti_options); in copy.c > regardless of if we've done any bulk inserts or not. Perhaps that > should be under an if (insertMethod != CIM_SINGLE) Yeah, good point. -- Michael
Commits
-
Fix missing calls to table_finish_bulk_insert during COPY, take 2
- f7c830f1ab26 13.0 landed
- b8ef33b2d145 12.0 landed
-
Fix missing call to table_finish_bulk_insert during COPY
- 4de60244e2fc 12.0 landed