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

From: Kevin Grittner
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Date: ,
Msg-id: 4D0CAA8C020000250003878E@gw.wicourts.gov
(view: Whole thread, Raw)
Responses: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?  (tuanhoanganh)
List: pgsql-performance

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

From: Royce Ausburn
Date:
Subject: Re: Auto-clustering?
From: Royce Ausburn
Date:
Subject: Re: Auto-clustering?