From: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
---|---|
To: | Dino Vliet <dino_vliet(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: why can't I increase shared buffers to higher value? |
Date: | 2007-03-01 00:24:35 |
Message-ID: | 20070228192435.ed666c75.wmoran@collaborativefusion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dino Vliet <dino_vliet(at)yahoo(dot)com> wrote:
>
> I have the following config but increasing the shared buffers to a value greater then 32 doesn't let the database server start (I want a value of 256MB there because I will have a giant table of 12 million rows which will be qeuried extremely).
>
> I have a 3GB RAM amd64 system running freebsd 6.1 with:
>
> Maintenance_work_mem is 32MB
> Max_stack_depth is 3MB
> Shared_buffers is 32MB
> Temp_buffers is 8MB
> Work_mem is 32MB
> Max_fsm_pages is 204800
> Max_connections is 3
>
> And I am doing this:
>
> sysctl -w kern.ipc.shmmax=1954311424
> sysctl -w kern.ipc.shmall=16384
>
> Why is my shared buffer value not increasing?
16384 is only 130M. Try using 238000 for shmall.
--
Bill Moran
Collaborative Fusion Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Naz Gassiep | 2007-03-01 00:38:52 | Re: Select retrieval slowdown after db drop/reload. Suggestions? |
Previous Message | Omar Eljumaily | 2007-03-01 00:19:02 | Why does "group by" need to match select fields? |