> -----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.
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2001-02-16 23:40:15|
|Subject: Re: v7.1b4 bad performance |
|Previous:||From: Gena Gurchonok||Date: 2001-02-16 22:30:17|
|Subject: Re: [GENERAL] what means "INSERT xxx yyy" ?|