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... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers