Skip site navigation (1) Skip section navigation (2)

Re: Vacuum analyse after a long time without one ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be>
Cc: Lewis Kapell <lkapell(at)setonhome(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum analyse after a long time without one ...
Date: 2009-09-11 16:50:00
Message-ID: 22271.1252687800@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be> writes:
> - I have 16Go of RAM on that server (but 32bits OS with bigmem kernel ; 
> so I set shared buffer to 350000 (~2,7GB) for a shmmax of 4000000000 
> (~3,8GB)

On a 32-bit machine that's just insane.  You've got something like 300MB
left over in the process address space (assuming the typical 1Gb for
kernel split).  No wonder things are falling over.  Try putting
shared_buffers somewhere around 1Gb.  Or switch to 64-bit.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Nicolas MichelDate: 2009-09-11 18:05:39
Subject: Re: Vacuum analyse after a long time without one ...
Previous:From: Nicolas MichelDate: 2009-09-11 16:26:25
Subject: Re: Vacuum analyse after a long time without one ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group