Horton
Menu

Re: Further pg_upgrade analysis for many tables

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Jeff Janes <jeff.janes@gmail.com>, Ants Aasma <ants@cybertec.at>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Magnus Hagander <magnus@hagander.net>, Andrew Dunstan <andrew@dunslane.net>
Date: 2013-01-20T19:11:48Z
Lists: pgsql-hackers 
Bruce Momjian <bruce@momjian.us> writes:
> ! 		 *	Using pg_restore --single-transaction is faster than other
> ! 		 *	methods, like --jobs.

Is this still the case now that Jeff's AtEOXact patch is in?  The risk
of locktable overflow with --single-transaction makes me think that
pg_upgrade should avoid it unless there is a *really* strong performance
case for it, and I fear your old measurements are now invalidated.

			regards, tom lane