Re: The black art of postgresql.conf tweaking

Gaetano,

> Of course your are speaking about the "worst case", I aplly in scenarios
like
> this on the rule 80/20: 80% of connection will perform a sort and 20% will
allocate
> memory for the sort operation in the same window time:

Well, I suppose it depends on how aggresive your connection pooling is.   If
you minimize idle connections, then 300 connections can mean 200 concurrent
queries.  And since Paul *is* having problems, this is worth looking into.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco