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  (Simon Riggs <simon@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: Strange query behavior where clause produces odd behavior on '>' query
Следующее
От: "Robert Haas"
Дата:
Сообщение: Re: BufferAccessStrategy for bulk insert