Re: A little COPY speedup

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: A little COPY speedup
Дата
Msg-id 12674.1172775931@sss.pgh.pa.us
обсуждение исходный текст
Ответ на A little COPY speedup  (Heikki Linnakangas <heikki@enterprisedb.com>)
Ответы Re: A little COPY speedup  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-patches
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> On every row, PageAddItem will scan all the line pointers on the target
> page, just to see that they're all in use, and create a new line
> pointer. That adds up, especially with narrow tuples like what I used in
> the test.
> Attached is a fix for that.

This has been proposed before, and rejected before.  IIRC the previous
patch was quite a lot less invasive than this one (it didn't require
making special space on heap pages).  I don't recall why it wasn't
accepted.

            regards, tom lane

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: A little COPY speedup
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Deadlock with pg_dump?