On Tue, 20 Oct 2009, Waldomiro wrote:
So, I put in sharedbuffers the same size my two biggest tables, which are the
most read too. 11 GB + 4 GB. total shared buffers = 15 GB
That seems quite reasonable. The rest of the unused RAM in the server is
going to be used by the operating system cach
On Tue, Oct 20, 2009 at 4:22 PM, Waldomiro wrote:
> Hi everybody,
>
> I have some doubts about sharedmemory and work_mem.
>
> I have a server:
>
> 64 GB RAM
> 2 processors 4 cores each one intel xeon 3 Ghz
> expecting 300 users in the same time
>
> So, I put in sharedbuffers the same size my two
Hi everybody,
I have some doubts about sharedmemory and work_mem.
I have a server:
64 GB RAM
2 processors 4 cores each one intel xeon 3 Ghz
expecting 300 users in the same time
So, I put in sharedbuffers the same size my two biggest tables, which
are the most read too. 11 GB + 4 GB. total sha