RE: v7.1b4 bad performance

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Friday, February 16, 2001 2:26 PM
> To: Schmidt, Peter
> Cc: 'Tom Lane'; 'Michael Ansley'; 'pgsql-admin(at)postgresql(dot)org'
> Subject: Re: [ADMIN] v7.1b4 bad performance
>
>
> > > This is very strange. Is there any specific query that
> is causing the
> > > problem? Does EXPLAIN show the same output on both versions?
> > >
> >
> >
> > "pgbench" doesn't execute any complex sql...
> >
> > Explain shows exactly the same output for both
> versions(7.03 & 7.1b4):
>
> I see. That is bad. All other reports have been that 7.1b4 is faster
> than 7.0.X. I am stumped.
>

There are several tools available for bench testing. pgbench seems like a
pretty good one for measuring database performance since it uses libpq
interface. Would you concur?

At this point I'm not concerned with comparing interface performance(i.e.
JDBC, ODBC, C++), C++ is bound to be the fastest. Also not concerned with
network or user interaction aspects of performance...yet. Does anyone know
how the "other reports" were gauged? Apparently, I am not the _only_ one
who has reproduced these results using pgbench.
Peter