> -----Original Message-----
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 16, 2001 2:26 PM
> To: Schmidt, Peter
> Cc: 'Tom Lane'; 'Michael Ansley'; '[EMAIL PROTECTED]'
> 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