Skip site navigation (1) Skip section navigation (2)

RE: [HACKERS] Re: v7.1b4 bad performance

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Hannu Krosing" <hannu(at)tm(dot)ee>
Cc: "Tatsuo Ishii" <t-ishii(at)sra(dot)co(dot)jp>, <pgsql-hackers(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: RE: [HACKERS] Re: v7.1b4 bad performance
Date: 2001-02-23 21:38:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-hackers
> -----Original Message-----
> From: Tom Lane
> Hannu Krosing <hannu(at)tm(dot)ee> writes:
> > Is this unmodified pgbench or has it Hiroshi tweaked behaviour of 
> > connecting each client to its own database, so that locking and such 
> > does not shade the possible benefits (was it about 15% ?) of delay>1
> I didn't much like that approach to altering the test, since it also
> means that all the clients are working with separate tables and hence
> not able to share read I/O; that doesn't seem like it's the same
> benchmark at all.

I agree with you at this point. Generally speaking the benchmark
has little meaning if it has no conflicts in the test case. I only
borrowed pgbench's source code to implement my test cases.
Note that there's only one database in my last test case. My
modified "pgbench" isn't a pgbench any more and I didn't intend
to change pgbench's spec like that. Probably it was my mistake
that I had posted my test cases using the form of patch.  My
intension was to clarify the difference of my test cases.
However heavy conflicts with scaling factor 1 doesn't seem
preferable at least as the default of pgbench.

Hiroshi Inoue 

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-02-23 21:46:02
Subject: Re: beta5 packages ...
Previous:From: Tom LaneDate: 2001-02-23 21:35:10
Subject: Re: beta5 packages ...

pgsql-admin by date

Next:From: Dave PageDate: 2001-02-23 22:04:25
Subject: RE: select * from pgadmin_users; causes error
Previous:From: Tom LaneDate: 2001-02-23 21:07:23
Subject: Re: select * from pgadmin_users; causes error

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group