Re: COPY blocking \dt+? - Mailing list pgsql-general

From David Rowley
Subject Re: COPY blocking \dt+?
Date
Msg-id CAApHDvr9mjOG7Rz+=QKqYW1TdCoWoGOMFxUqA8w+du-HxpEw1g@mail.gmail.com
Whole thread Raw
In response to Re: COPY blocking \dt+?  (pinker <pinker@onet.eu>)
List pgsql-general
On Tue, 5 May 2020 at 14:50, pinker <pinker@onet.eu> wrote:
> So it would need to run inside single transaction to cause lock, right? do
> you know if pgbench is opening transaction?

The TRUNCATE and COPY are done in the same transaction.  You can see
the code in https://github.com/postgres/postgres/blob/REL_11_6/src/bin/pgbench/pgbench.c#L3599

David



pgsql-general by date:

Previous
From: pinker
Date:
Subject: Re: COPY blocking \dt+?
Next
From: Jean Claude
Date:
Subject: Migration from Oracle to Postgres