Bruce Momjian <br...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers