| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Rainer Bauer <usenet(at)munnin(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |
| Date: | 2007-10-22 14:33:17 |
| Message-ID: | 20071022143317.GM15375@svr2.hagander.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Mon, Oct 22, 2007 at 04:03:35PM +0200, Rainer Bauer wrote:
> >> shared_buffers = 512MB
> >
> >As a general note, thsi is *way* too high. All evidence I've seen points to
> >that you should have shared_buffers as *small* as possible on win32,
> >because memory access there is slow. And leave more of the caching up to
> >the OS.
>
> I followed Josh's advice here:
> <http://archives.postgresql.org/pgsql-performance/2007-06/msg00606.php>
>
> What value would you recommend then? The default 32MB?
That advice is good - for Unix platforms. For windows, yes, try with 32Mb.
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2007-10-22 14:38:07 | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |
| Previous Message | Erik Jones | 2007-10-22 14:28:28 | Re: looking for some real world performance numbers |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-10-22 14:36:04 | Re: Latin vs non-Latin words in text search parsing |
| Previous Message | Kevin Grittner | 2007-10-22 14:31:23 | IN vs EXISTS equivalence |