Re: BufferAccessStrategy for bulk insert - Mailing list pgsql-hackers

From Robert Haas
Subject Re: BufferAccessStrategy for bulk insert
Date
Msg-id 603c8f070810301946m264bdb8ap2838cf9f467e1c18@mail.gmail.com
Whole thread Raw
In response to Re: BufferAccessStrategy for bulk insert  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: BufferAccessStrategy for bulk insert
List 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

Attachment

pgsql-hackers by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Strange query behavior where clause produces odd behavior on '>' query
Next
From: "Robert Haas"
Date:
Subject: Re: BufferAccessStrategy for bulk insert