Re: COPY threads - Mailing list pgsql-general

From Andres Freund
Subject Re: COPY threads
Date
Msg-id 20181010210729.ewntjynvutnlgdn2@alap3.anarazel.de
Whole thread Raw
In response to Re: COPY threads  (Ravi Krishna <srkrishna1@aol.com>)
Responses Re: COPY threads
List pgsql-general
Hi,

On 2018-10-10 17:02:59 -0400, Ravi Krishna wrote:
> 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_restore doesn't take locks on the table for the COPY, it does so
because creating the table takes an exclusive lock.

Greetings,

Andres Freund


pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Re: COPY threads
Next
From: Ravi Krishna
Date:
Subject: Re: COPY threads