Re: Inserting heap tuples in bulk in COPY

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Inserting heap tuples in bulk in COPY
Дата
Msg-id 4E45A231.8040603@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Inserting heap tuples in bulk in COPY  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Inserting heap tuples in bulk in COPY  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Johann 'Myrkraverk' Oskarsson"
Дата:
Сообщение: Re: USECS_* constants undefined with float8 timestamps?
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Inserting heap tuples in bulk in COPY