Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?

[tuanhoanganh <hatuan05@xxxxxxxxx>]

No, I don't use SSL. Here is my pg_hba.conf
# IPv4 local connections:
hostÂÂÂ allÂÂÂÂÂÂÂÂÂÂÂÂ allÂÂÂÂÂÂÂÂÂÂÂÂ 0.0.0.0/0ÂÂÂÂÂÂÂÂÂÂÂ trust
# IPv6 local connections:
hostÂÂÂ allÂÂÂÂÂÂÂÂÂÂÂÂ allÂÂÂÂÂÂÂÂÂÂÂÂ ::1/128ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ trust

On Sun, Dec 19, 2010 at 1:35 AM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote:

> tuanhoanganh Âwrote:

> tps = 20.143494 (including connections establishing)
> tps = 256.630260 (excluding connections establishing)
>
> Why pgbench on my server is very low or is it common value with my
> server ?

Those numbers look pretty low to me. ÂI would start with looking at
why it is taking so long to establish a TCP connection. ÂAre you
using SSL? ÂHow are you authenticating?

-Kevin