Re: Inserting heap tuples in bulk in COPY - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Inserting heap tuples in bulk in COPY
Date
Msg-id CAMkU=1x+VXw+i5ob8ihSNuqOFB7oODzuRnowZk+nuMZdmTK8Hw@mail.gmail.com
Whole thread Raw
In response to Re: Inserting heap tuples in bulk in COPY  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Inserting heap tuples in bulk in COPY
List pgsql-hackers
On Fri, Aug 12, 2011 at 2:59 PM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> 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.

Hi Heikki,

Is the bulk index insert still an active area for you?

If not, is there some kind of summary of design or analysis work
already done, which would be a useful for someone else interested in
picking it up?

Thanks,

Jeff


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: pg_pretty_query
Next
From: Peter Geoghegan
Date:
Subject: Re: WIP: pg_pretty_query