Re: [JDBC] Using a COPY...FROM through JDBC?

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: [JDBC] Using a COPY...FROM through JDBC?
Дата
Msg-id Pine.BSO.4.56.0406071636550.6042@leary.csoft.net
обсуждение исходный текст
Ответ на Re: [JDBC] Using a COPY...FROM through JDBC?  (Steve Wampler <swampler@noao.edu>)
Список pgsql-performance

On Mon, 7 Jun 2004, Steve Wampler wrote:

> I do have a little concern about what's happening in the
> back end during the copy - I suspect the entire table is
> locked, which may impact the performance when multiple
> clients are saving entries into the table.  Anyone know
> if that's how COPY works?  (For that matter, would that
> also be true of a transaction consisting of a set of
> inserts?)
>

The table is not locked in either the copy or the insert case.

Kris Jurka

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

Предыдущее
От: "Dan Langille"
Дата:
Сообщение: Re: seq scan woes
Следующее
От: Josué Maldonado
Дата:
Сообщение: Join slow on "large" tables