Re: v7.1b4 bad performance

> > "Schmidt, Peter" <peter(dot)schmidt(at)prismedia(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026