Re: CopyReadAttributesCSV optimization

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: CopyReadAttributesCSV optimization
Дата
Msg-id 47D1DACB.8020108@dunslane.net
обсуждение исходный текст
Ответ на CopyReadAttributesCSV optimization  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Ответы Re: CopyReadAttributesCSV optimization  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список pgsql-patches

Heikki Linnakangas wrote:
> Here's a patch to speed up CopyReadAttributesCSV. On the test case
> I've been playing with, loading the TPC-H partsupp table, about 20%
> CopyReadAttributesCSV (inlined into DoCopy, DoCopy itself is
> insignificant):
>
>
[snip]
>
> The trick is to split the loop in CopyReadAttributesCSV into two
> parts, inside quotes, and outside quotes, saving some instructions in
> both parts.
>
> Your mileage may vary, but I'm quite happy with this. I haven't tested
> it much yet, but I wouldn't expect it to be a loss in any interesting
> scenario. The code also doesn't look much worse after the patch,
> perhaps even better.
>
>

This looks sane enough, and worked for me in testing, so I'm going to
apply it shortly. I'll probably add a comment or two about how the loops
interact.

cheers

andrew

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Proposed patch to change TOAST compression strategy
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Remove FATAL from pg_lzdecompress