Re: Any better plan for this query?.. - Mailing list pgsql-performance

From Glenn Maynard
Subject Re: Any better plan for this query?..
Date
Msg-id bd36f99e0905121452j47c60981h12a9ac2e7f0bc224@mail.gmail.com
Whole thread Raw
In response to Re: Any better plan for this query?..  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Any better plan for this query?..  (Dimitri <dimitrik.fr@gmail.com>)
Re: Any better plan for this query?..  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
I'm sorry, but I'm confused.  Everyone keeps talking about connection
pooling, but Dimitri has said repeatedly that each client makes a
single connection and then keeps it open until the end of the test,
not that it makes a single connection per SQL query.  Connection
startup costs shouldn't be an issue.  Am I missing something here?
test(N) starts N clients, each client creates a single connection and
hammers the server for a while on that connection.  test(N) is run for
N=1,2,4,8...256.  This seems like a very reasonable test scenario.

--
Glenn Maynard

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Any better plan for this query?..
Next
From: Scott Marlowe
Date:
Subject: Re: AMD Shanghai versus Intel Nehalem