Using COPY FREEZE with pg_restore --single-transaction - Mailing list pgsql-hackers

From Bruce Momjian
Subject Using COPY FREEZE with pg_restore --single-transaction
Date
Msg-id 20130125152433.GY21914@momjian.us
Whole thread Raw
Responses Re: Using COPY FREEZE with pg_restore --single-transaction
List pgsql-hackers
pg_restore --single-transaction has the setup to make use of the new
COPY FREEZE optimization.

However, I don't see us using COPY FREEZE for pg_restore
--single-transaction.  Shouldn't we do that?  The problem is we would
need to have pg_dump emit the FREEZE, which would cause it not to load
in earlier versions of Postgres, and to (soon) emit a NOTICE for
non-single-transaction loads in all other cases.  :-(

Can pg_restore inject FREEZE itself when it does the copy?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Skip checkpoint on promoting from streaming replication
Next
From: Bernd Helmle
Date:
Subject: Hanging backends and possible index corruption