Re: COPY locking

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: COPY locking
Дата
Msg-id 4533.989450546@sss.pgh.pa.us
обсуждение исходный текст
Ответ на COPY locking  (John Coers <coers@intrinsity.com>)
Список pgsql-general
John Coers <coers@intrinsity.com> writes:
> I am trying to figure out what is slowing down multiple concurrent COPY
> commands to my database and all I see is lots of semops.

Are you talking about concurrent copies into the same table?  That would
suffer a lot of short-term lock interference, no doubt, since all the
copies are going to be writing the same disk page (ie, the current last
page of the table).

            regards, tom lane

В списке pgsql-general по дате отправления: