Message-ID: <b61855b9dd042f35c1b1727d30bb92946d3c8c3a.camel@cybertec.at>
Subject: Re: Experience and feedback on pg_restore --data-only
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Dimitrios Apostolou <jimis@gmx.net>, Adrian Klaver
	 <adrian.klaver@aklaver.com>
Cc: pgsql-general@lists.postgresql.org
Date: Mon, 24 Mar 2025 19:41:35 +0100
In-Reply-To: <7e990eae-e55c-0d04-1be8-f49bb3251073@gmx.net>
References: <53760c70-4a87-a453-9e02-57abc9cb2e54@gmx.net>
	 <455d28421ae33c73b73a6f527d2f72816ca5dd29.camel@cybertec.at>
	 <5f1ebeda-f080-cb31-75c0-ce2211ea348f@gmx.net>
	 <832c1cdd-c0fe-464b-b4b9-f9d0482b9b78@aklaver.com>
	 <7e990eae-e55c-0d04-1be8-f49bb3251073@gmx.net>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/b61855b9dd042f35c1b1727d30bb92946d3c8c3a.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-03-24 at 16:51 +0100, Dimitrios Apostolou wrote:
> Laurenz informed me that I could avoid writing to the WAL if I "create an=
d
> load the table in a single transaction".
> I haven't tried, but here is what I would do to try --single-transaction:
>=20
> Transaction 1: manually issuing all of CREATE TABLE etc.
>=20
> Transaction 2: pg_restore --single-transaction --data-only
>=20
> The COPY command in transaction 2 would still need to write to WAL, since
> it's separate from the CREATE TABLE.
>=20
> Am I wrong somewhere?

No, that is correct.

Yours,
Laurenz Albe