On Tue, Sep 29, 2009 at 12:07 PM, <lst_hoe02@xxxxxxxxx> wrote:
Zitat von Aras Angelo <araskoktas@xxxxxxxxx>: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.
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.
Regards
Andreas
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
