Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? - Mailing list pgsql-performance

From tuanhoanganh
Subject Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Date
Msg-id AANLkTimGXmhW1AWm=ER4aU9zOpW1-JVp566GLjjaP8+D@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view
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@wicourts.gov> 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

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Next
From: tuanhoanganh
Date:
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?