Re: Any better plan for this query?..

From: Glenn Maynard <glennfmaynard(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Any better plan for this query?..
Date: 2009-05-12 21:52:13
Message-ID: bd36f99e0905121452j47c60981h12a9ac2e7f0bc224@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thomas Finneid 2009-05-12 21:52:23 increase index performance
Previous Message Rafael Martinez 2009-05-12 21:25:02 Re: Query planner making bad decisions