On Wed, Mar 06, 2019 at 10:06:27PM +0800, Paul Guo wrote: > Hello, Postgres hackers, > > The copy code has used batch insert with function heap_multi_insert() to > speed up. It seems that Create Table As or Materialized View could leverage > that code also to boost the performance also. Attached is a patch to > implement that.
This is great! Is this optimization doable for multi-row INSERTs, either with tuples spelled out in the body of the query or in constructs like INSERT ... SELECT ...? Best, David. -- David Fetter <david(at)fetter(dot)org> http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate