Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group