Re: COPY threads

From: Ravi Krishna <srkrishna1(at)aol(dot)com>
To: Christopher Browne <cbbrowne(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, laurenz(dot)albe(at)cybertec(dot)at, Rob Sargent <robjsargent(at)gmail(dot)com>, PostgreSQL Mailing Lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY threads
Date: 2018-10-10 21:02:59
Message-ID: 7FCA0163-130B-474D-BE00-3BB5D2E0EC89@aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2018-10-10 21:07:29 Re: COPY threads
Previous Message Christopher Browne 2018-10-10 20:32:07 Re: COPY threads