Tom Lane wrote:
Simon Riggs <[EMAIL PROTECTED]> writes:
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
samples % symbol name
55526 16.5614 LWLockAcquire
29721 8.8647 DoCopy
26581 7.9281 CopyReadLine
25105 7.4879 LWLockRelease
15743 4.6956 PinBuffer
14725 4.3919 heap_formtuple
Probably loading a table with a generated PK or loading data in
ascending sequence, so its contending heavily for the rightmost edge of
the index.
No, given that DoCopy and CopyReadLine are right up there, I think we're
still looking at the COPY phase, not index building.
The profile will probably change completely once index building
starts...
yeah this profile is only showing the COPY phase ...
Stefan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers