Re: Further pg_upgrade analysis for many tables

On Tue, Nov 27, 2012 at 09:35:10PM -0800, Jeff Janes wrote:
> > I tested custom format with pg_restore -j and -1, as well as text
> > restore.  The winner was pg_dump -Fc | pg_restore -1;
> 
> I don't have the numbers at hand, but if my relcache patch is
> accepted, then "-1" stops being faster.
> 
> -1 gets rid of the AtOEXAct relcache N^2 behavior, but at the cost of
> invoking a different N^2, that one in the stats system.

OK, here are the testing results:
#tbls       git     -1    AtOEXAct  both    1      11.06   13.06   10.99   13.20 1000      21.71   22.92   22.20
22.512000      32.86   31.09   32.51   31.62 4000      55.22   49.96   52.50   49.99 8000     105.34   82.10   95.32
82.9416000    223.67  164.27  187.40  159.5332000     543.93  324.63  366.44  317.9364000    1697.14  791.82  767.32
752.57

Up to 2k, they are all similar.  4k & 8k have the -1 patch as a win, and
16k+ really need both patches.

I will continue working on the -1 patch, and hopefully we can get your
AtOEXAct patch in soon.  Is someone reviewing that?

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