Re: Memory Problem

From: Flavio Henrique Araque Gurgel <flavio(at)4linux(dot)com(dot)br>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Cc: Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be>
Subject: Re: Memory Problem
Date: 2009-04-04 13:58:45
Message-ID: 7078651.381341238853525112.JavaMail.root@mail.4linux.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello!

> Thank you very much. I didn't know that. I set my shmmax to 4000000000 but you're right, we will see to use a 64 bits system ;)

My experience with this amount of memory in Debian Etch works much better in a 64bit environment. BIGMEM kernel handles pages in a way that the performance is a bit degraded.

> I wanted to give to postgres 4GB. So I tryied to set shmmax to 4Go :
>
> sysctl kernel.shmmax=4294967296
>
>
> But it doesn't work : if I launch after this modification this command :
>
> sysctl kernel.shmmax
>
> it gives me this response :
>
> kernel.shmmax = 0
>
> Why? Is there a limit to shmmax?

I don't see limits in shmmax but the command you're typing is wrong.
To set a value you need to do:
sysctl -w kernel.shmmax=VALUE

or alternatively:
cat VALUE > /proc/sys/kernel/shmmax

Don't forget to write in your /etc/sysctl.conf:
kernel.shmmax=VALUE
Without spaces. This will make your setting persistent.

Regards
Flavio

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nicolas Michel 2009-04-04 15:30:24 [Fwd: Re: Memory Problem]
Previous Message Carol Walter 2009-04-03 18:32:02 Full text searching