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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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