Thread: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
> 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
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
# 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@wicourts.gov> wrote:
> tuanhoanganh wrote:Those numbers look pretty low to me. I would start with looking at
> 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 ?
why it is taking so long to establish a TCP connection. Are you
using SSL? How are you authenticating?
-Kevin