Sorry i forgot to mention it, max cli setting is 500. On Tue, Sep 29, 2009 at 12:07 PM, <[email protected]> wrote:
> Zitat von Aras Angelo <[email protected]>: > > I have this server, Dual Intel Xeon 2.83GHz w 4gb ram. >> My shared buffers were set to 1756 MB. >> >> We have a high traffic e-commerce site, yesterday like 80000 uniques. >> We cache most of our dynamic pages to disk so its wierd we are experience >> really slow response times with postgresql. >> >> Usually the number of simultaneous connections i monitor is around 8 to >> 10, >> but yesterday night, maybe there was a spike in the traffic, it was going >> up >> to 100, so the pages were taking like 15 seconds to render. >> > > As far as i know the default for max_connections is "100" on many Linux > Distros. This would explain why your web-app is slow when reaching this > limit. > > Regards > > Andreas > > > > > -- > Sent via pgsql-admin mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
