Re: high loads, fine tuning

Поиск
Список
Период
Сортировка
От lst_hoe02@kwsoft.de
Тема Re: high loads, fine tuning
Дата
Msg-id 20090929210749.20304dejy9sa6bs4@webmail.kwsoft.de
обсуждение исходный текст
Ответ на high loads, fine tuning  (Aras Angelo <araskoktas@gmail.com>)
Ответы Re: high loads, fine tuning  (Aras Angelo <araskoktas@gmail.com>)
Список pgsql-admin
Zitat von Aras Angelo <araskoktas@gmail.com>:

> 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




В списке pgsql-admin по дате отправления:

Предыдущее
От: Aras Angelo
Дата:
Сообщение: high loads, fine tuning
Следующее
От: Aras Angelo
Дата:
Сообщение: Re: high loads, fine tuning