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