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

From Jeff Janes
Subject Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Date
Msg-id AANLkTi=7jdYZt9+WtvOwDW-T2zBByxMjbSM4xahquP3G@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?  (tuanhoanganh <hatuan05@gmail.com>)
List pgsql-performance
What you still haven't clarified is how long each exe/user combo keeps
the connection open for.

If for a day, then who cares that it takes 4 seconds each morning to
open them all?

If for a fraction of a second, then you do not need 200 simultaneous
open connections, they can probably share a much smaller number.  That
is the whole point of pooling.

Cheers,

Jeff

pgsql-performance by date:

Previous
From: tuanhoanganh
Date:
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Next
From: Desmond Coertzen
Date:
Subject: Create index on subfield returned by function that returns base type with sub fields