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: (view raw, whole thread or download thread mbox)
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.



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-2017 The PostgreSQL Global Development Group