Re: [PERFORM] Limited Shared Buffer Problem

Cédric Villemain wrote: AFAIK effective_cache_size is estimation of OS Page Cache + Estimated Cache in shared_buffers. Yes, the total value you set is used as is, and should include both pieces of memory. The planner doesn't add the shared_buffers value to the total first for you, as some

Re: [PERFORM] Limited Shared Buffer Problem

Thanx, I will try out that recommendation. On Fri, Jan 29, 2010 at 11:53 AM, Richard Neill wrote: > > > **Rod MacNeil wrote: > >> Hi All, >> >> I have a server running CentOS5 with 6gb of memory that will run postgres >> 8.3 exclusively. >> I would like to allocate 4gb of the memory to shared b

Re: [PERFORM] Limited Shared Buffer Problem

2010/1/29 Richard Neill : > > > **Rod MacNeil wrote: >> >> Hi All, >> >> I have a server running CentOS5 with 6gb of memory that will run postgres >> 8.3 exclusively. >> I would like to allocate 4gb of the memory to shared buffers for postgres. > > It might be worth pausing at this point: > > The v

Re: [PERFORM] Limited Shared Buffer Problem

You are probably running 32bit OS. So the problem is that the OS cannot allocate more than 3G of memory continuous . Then the only solution is to migrate to a 64bit OS. 2010/1/29 **Rod MacNeil : > Hi All, > > I have a server running CentOS5 with 6gb of memory that will run postgres > 8.3 exclusive

Re: [PERFORM] Limited Shared Buffer Problem

Richard Neill escribió: **Rod MacNeil wrote: Hi All, I have a server running CentOS5 with 6gb of memory that will run postgres 8.3 exclusively. I would like to allocate 4gb of the memory to shared buffers for postgres. It might be worth pausing at this point: The various postgresql tunin

Re: [PERFORM] Limited Shared Buffer Problem

On Fri, Jan 29, 2010 at 9:37 AM, **Rod MacNeil wrote: > Hi All, > > I have a server running CentOS5 with 6gb of memory that will run postgres > 8.3 exclusively. > I would like to allocate 4gb of the memory to shared buffers for postgres. > I have modified some kernel settings as follows: > > shmal

Re: [PERFORM] Limited Shared Buffer Problem

**Rod MacNeil wrote: Hi All, I have a server running CentOS5 with 6gb of memory that will run postgres 8.3 exclusively. I would like to allocate 4gb of the memory to shared buffers for postgres. It might be worth pausing at this point: The various postgresql tuning guides usually suggest

[PERFORM] Limited Shared Buffer Problem

Hi All, I have a server running CentOS5 with 6gb of memory that will run postgres 8.3 exclusively. I would like to allocate 4gb of the memory to shared buffers for postgres. I have modified some kernel settings as follows: shmall 1048576 pages 4,294,967,296 bytes shmmax 4,294,967,295 bytes I c