Re: Inserting heap tuples in bulk in COPY

On 13.08.2011 00:17, Simon Riggs wrote:
> Also, we discussed that you would work on buffering the index inserts,
> which is where the main problem lies. The main heap is only a small
> part of the overhead if we have multiple indexes already built on a
> table - which is the use case that causes the most problem.

Sure, if you have indexes on the table already, then the overhead of 
updating them is more significant. I am actually working on that too, I 
will make a separate post about that.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com