Re: Win32 Backend Cash - pre-existing shared memory block is still in use

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Jeremy Palmer <JPalmer(at)linz(dot)govt(dot)nz>, Magnus Hagander <magnus(at)hagander(dot)net>, "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-25 05:23:19
Message-ID: 12542.1282713799@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> 512M is still REALLY high for a 32 bit postgresql. Have you tried
> something in the 16Meg range?

Cutting his value for shared_buffers (currently about 800MB) might be
wise too. I'm not sure what the effectively available address space
for a win32 process is, but if there's any inefficiency in the way
the address space is laid out, those numbers could be enough to be
trouble.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-08-25 05:28:29 Re: Win32 Backend Cash - pre-existing shared memory block is still in use
Previous Message Jeremy Palmer 2010-08-25 05:21:59 Re: Win32 Backend Cash - pre-existing shared memory block is still in use