Re: [GENERAL] Sharedbuffers and WorkMem

2009-10-20 Thread Greg Smith
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

Re: [GENERAL] Sharedbuffers and WorkMem

2009-10-20 Thread Grzegorz Jaƛkiewicz
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

[GENERAL] Sharedbuffers and WorkMem

2009-10-20 Thread Waldomiro
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