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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: tuanhoanganh <hatuan05(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Date: 2010-12-23 16:37:51
Message-ID: AANLkTi=7jdYZt9+WtvOwDW-T2zBByxMjbSM4xahquP3G@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Desmond Coertzen 2010-12-23 16:53:24 Create index on subfield returned by function that returns base type with sub fields
Previous Message Desmond Coertzen 2010-12-23 16:34:31 Index on function that returns type with sub fields