Обсуждение: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?

От:
"Kevin Grittner"
Дата:

> 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

От:
tuanhoanganh
Дата:

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 <> 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