| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Jeremy Palmer <JPalmer(at)linz(dot)govt(dot)nz>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Subject: | Re: Win32 Backend Cash - pre-existing shared memory block is still in use |
| Date: | 2010-08-19 13:46:17 |
| Message-ID: | AANLkTini8WSviPm4ybGZh1JAcO=OBQQd2QhChWCmSPcS@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 19, 2010 at 15:42, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Jeremy Palmer <JPalmer(at)linz(dot)govt(dot)nz> writes:
>> Could it be that I have too much memory allocated for postgresql? My resource settings are:
>> shared_buffers = 94952
>> temp_buffers = 1GB
>> work_mem = 19339
>> maintenance_work_mem = 191845
>> max_stack_depth = 2MB
>
> 1GB for temp_buffers is a *LOT*. You do realize that's per backend?
> Those other settings don't look too unreasonable.
Definitely - particularly since this is a 32-bit version, that's
getting very close to the address space limits...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Derrick Rice | 2010-08-19 15:23:22 | Re: Warm Standby and resetting the primary as a standby |
| Previous Message | Tom Lane | 2010-08-19 13:42:21 | Re: Win32 Backend Cash - pre-existing shared memory block is still in use |