Re: COPY threads - Mailing list pgsql-general

From Ravi Krishna
Subject Re: COPY threads
Date
Msg-id 7FCA0163-130B-474D-BE00-3BB5D2E0EC89@aol.com
Whole thread Raw
In response to Re: COPY threads  (Christopher Browne <cbbrowne@gmail.com>)
Responses Re: COPY threads  (Andres Freund <andres@anarazel.de>)
List pgsql-general
>
> No, why would that seem to be the case?  If it did so, then you could
> not run pg_dump to dump data while regular activity was going on.


Not sure. In fact I am now confused.
I am talking about pg_restore which is COPY FROM, which takes exclusive lock on the table
while the data is loaded into the table.
pg_dump does COPY TO which reads data out of the table to a file or something else.

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: COPY threads
Next
From: Andres Freund
Date:
Subject: Re: COPY threads