Re: v7.1b4 bad performance

> > "Schmidt, Peter" <peter.schmidt@prismedia.com> writes:
> > > However, what I'm interested in is the comparison between
> > 7.0x and 7.1x.
> > > Shouldn't the 7.1b4 database be faster? Have you (or anyone
> > else) done this
> > > comparison?
> >
> > 7.1 is considerably faster if you compare performance without -F.
> > If you are comparing performance with -F, I'm not sure exactly how it
> > stacks up.
> >
> >             regards, tom lane
> >
>
> Here are some of the results of my tests which are very consistent.  I
> dropped and recreated postgres db before each test so the only user tables
> were the pgbench tables.
>
> 7.1b4(no -F)    49 tps
> 7.03 (no -F)    64 tps
> 7.03 (with -F)    121 tps
>
> The test machine is a Dell Dimension 800mz w/128 RAM and it is dedicated to
> this testing. Pgbench is run on the same machine. Any ideas why my results
> differ? I will continue testing and appreciate all comments.
> Peter

This is very strange.  Is there any specific query that is causing the
problem?  Does EXPLAIN show the same output on both versions?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026