Postgres Pro
Downloads
Home   >   mailing lists

Re: 'COPY ... FROM' inserts to btree, blocks on buffer writeout - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 'COPY ... FROM' inserts to btree, blocks on buffer writeout
Date
Msg-id 11524.1104521165@sss.pgh.pa.us
Whole thread Raw
In response to 'COPY ... FROM' inserts to btree, blocks on buffer writeout  (Michael Wildpaner <mike@rainbow.studorg.tuwien.ac.at>)
Responses Re: 'COPY ... FROM' inserts to btree, blocks on buffer
List pgsql-hackers
Tree view 
Michael Wildpaner <mike@rainbow.studorg.tuwien.ac.at> writes:
> two concurrent clients try to 'COPY ... FROM ...' to the same table,
> "feature_link".

> The second one (pid 17983) is waiting for an ExclusiveLock on the table's
> primary key index, "key__idpk__flink".

You didn't show a stack trace for this one ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: contrib regression on old versions
Next
From: Tom Lane
Date:
Subject: Re: contrib regression on old versions