Re: Inserting heap tuples in bulk in COPY

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Inserting heap tuples in bulk in COPY
Дата
Msg-id CAMkU=1x+VXw+i5ob8ihSNuqOFB7oODzuRnowZk+nuMZdmTK8Hw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Inserting heap tuples in bulk in COPY  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Inserting heap tuples in bulk in COPY
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: WIP: pg_pretty_query
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: WIP: pg_pretty_query