Joshua D. Drake spaketh:
> On Thu, 2009-01-08 at 12:51 -0700, Gregory Williamson wrote:
> > Thom Brown wrote:
> > <...>
> > > I actually mentioned pgPool II to my boss earlier, and it's
> > something we
> > > will have to seriously consider, but will have to do some research
> > first.
<...>
> > U
On Thu, 2009-01-08 at 12:51 -0700, Gregory Williamson wrote:
> Thom Brown wrote:
> <...>
> > I actually mentioned pgPool II to my boss earlier, and it's
> something we
> > will have to seriously consider, but will have to do some research
> first.
>
> We had an application ported from Informix whi
Thom Brown wrote:
<...>
> I actually mentioned pgPool II to my boss earlier, and it's something we
> will have to seriously consider, but will have to do some research first.
We had an application ported from Informix which initially required 1000+
connections to handle peak load (one of 4 server
Thom Brown wrote:
> This database server is currently serving 3 very very busy multi-core web
> servers, and we're about to add another 3 to help deal with the load.
>
> I'm afraid that upgrading is not an option at present because it's in
> production.
Upgrading within the 8.3 series should invo
This database server is currently serving 3 very very busy multi-core web
servers, and we're about to add another 3 to help deal with the load.
I'm afraid that upgrading is not an option at present because it's in
production.
I've taken the suggestion of increasing shared buffers and now got
max_
Thom Brown wrote:
> It is running on 64-bit Gentoo 2.6.25.
>
> You might be right about needing to increase the shared buffers. Thanks for
> the suggestion. I'll have to give that a try
If shared_buffers was so small that you can't handle the connections you
might benefit from one of the links
It is running on 64-bit Gentoo 2.6.25.
You might be right about needing to increase the shared buffers. Thanks for
the suggestion. I'll have to give that a try
2009/1/8 Harald Armin Massa
> Thom,
>
> > I have a server running 8.3.1 with 16Gb of memory and 8x2.5Ghz cores.
> The
> > max_connec
Thom,
> I have a server running 8.3.1 with 16Gb of memory and 8x2.5Ghz cores. The
> max_connections was set to 100 (the default), but we were getting denied
> connections because it had exceeded the max. We increased this to a modest
> 250, stopped the service, and then tried to start. It would
