Re: Memory usage per postmaster process - Mailing list pgsql-general

From John R Pierce
Subject Re: Memory usage per postmaster process
Date
Msg-id 527548B9.5020403@hogranch.com
Whole thread Raw
In response to Memory usage per postmaster process  (Grzegorz Tańczyk <goliatus@polzone.pl>)
Responses Re: [100% SPAM] Re: Memory usage per postmaster process
List pgsql-general
On 11/2/2013 11:03 AM, Grzegorz Tańczyk wrote:
>
> Is there any way to limit total memory usage by postgres and keep
> maximum connections limit? Postgresql.conf settings are default for
> 8.3.23. I need to have 100 connections in pool.

the size of your connection pool shouldn't be much more than 2-3 times
the CPU core count on the server for optimal throughput... 100 queries
running at once will grind ANY non-monster server to a standstill




--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Grzegorz Tańczyk
Date:
Subject: Memory usage per postmaster process
Next
From: Grzegorz Tańczyk
Date:
Subject: Re: [100% SPAM] Re: Memory usage per postmaster process