Re: [JDBC] Using a COPY...FROM through JDBC? - Mailing list pgsql-performance

From Kris Jurka
Subject Re: [JDBC] Using a COPY...FROM through JDBC?
Date
Msg-id Pine.BSO.4.56.0406071636550.6042@leary.csoft.net
Whole thread Raw
In response to Re: [JDBC] Using a COPY...FROM through JDBC?  (Steve Wampler <swampler@noao.edu>)
List 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 by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: seq scan woes
Next
From: Josué Maldonado
Date:
Subject: Join slow on "large" tables