Re: Speed... - Mailing list pgsql-general

From Tom Lane
Subject Re: Speed...
Date
Msg-id 7803.993311763@sss.pgh.pa.us
Whole thread Raw
In response to RE: Speed...  ("Tim Mickol" <tmickol@combimatrix.com>)
List pgsql-general
"Tim Mickol" <tmickol@combimatrix.com> writes:
> some quick (and I might add disappointing) benchmark results...

As has been pointed out before, you must use a pgbench scale factor
higher than one if you are interested in making meaningful measurements
for more than one concurrent client.  At scale one, there is only one
"branch", so *every* transaction needs to update the same branch
balance, so there's effectively no concurrency.

            regards, tom lane

pgsql-general by date:

Previous
From: "Svenne Krap"
Date:
Subject: Re: Speed...
Next
From: Daniel Åkerud
Date:
Subject: Re: TCP/IP Sockets, UNIX Sockets