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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
