Re: COPY threads

From: Andres Freund <andres(at)anarazel(dot)de>
To: Ravi Krishna <srkrishna1(at)aol(dot)com>
Cc: Christopher Browne <cbbrowne(at)gmail(dot)com>, 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:07:29
Message-ID: 20181010210729.ewntjynvutnlgdn2@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2018-10-10 21:15:19 Re: COPY threads
Previous Message Ravi Krishna 2018-10-10 21:02:59 Re: COPY threads