Re: large dataset with write vs read clients

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: large dataset with write vs read clients
Дата
Msg-id 20101007185748.GZ26232@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: large dataset with write vs read clients  (Dan Harris <fbsd@drivefaster.net>)
Список pgsql-performance
* Dan Harris (fbsd@drivefaster.net) wrote:
>  On 10/7/10 11:47 AM, Aaron Turner wrote:
>> Basically, each connection is taking about 100MB resident.  As we need
>> to increase the number of threads to be able to query all the devices
>> in the 5 minute window, we're running out of memory.
> I think the first thing to do is look into using a connection pooler
> like pgpool to reduce your connection memory overhead.

Yeah..  Having the number of database connections be close to the number
of processors is usually recommended.

    Stephen

Вложения

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

Предыдущее
От: Dan Harris
Дата:
Сообщение: Re: large dataset with write vs read clients
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: large dataset with write vs read clients