Re: BufferAccessStrategy for bulk insert

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: BufferAccessStrategy for bulk insert
Дата
Msg-id 603c8f070810301946m264bdb8ap2838cf9f467e1c18@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BufferAccessStrategy for bulk insert  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: BufferAccessStrategy for bulk insert
Список pgsql-hackers
> You should try profiling the patch. You can count the invocations of the
> buffer access routines to check its all working in the right ratios.

*goes and learns how to do profile PostgreSQL*

OK, that was a good suggestion.  It looks like part of my problem here
is that I didn't put the CREATE TABLE and the COPY into the same
transaction.  As a result, a lot of time was spent on XLogInsert.
Modified the test case, new profiling results attached.

...Robert

Вложения

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