Dean,
> Here's the problem. A simple select statement takes upto 30 seconds to
respond, if I add in connection pooling and 15 - 20 concurrent requests the
responses are now 15-20 minutes!! I have no idea what the tuning options may
be, but I need to get these queries running in 30 seconds or so.
>
> Any ideas?
Nope, not a sausage. Not based on the quantity of information you've given
us.
Please read:
http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines
And re-post your question. Thanks!
--
-Josh Berkus
Aglio Database Solutions
San Francisco