Re: Needed: Simplified guide to optimal memory configuration - Mailing list pgsql-performance

From Tom Lane
Subject Re: Needed: Simplified guide to optimal memory configuration
Date
Msg-id 2608.1118845105@sss.pgh.pa.us
Whole thread Raw
In response to Re: Needed: Simplified guide to optimal memory configuration  (Dennis Bjorklund <db@zigo.dhs.org>)
Responses Re: Needed: Simplified guide to optimal memory configuration  (Todd Landfried <tlandfried@viatornetworks.com>)
List pgsql-performance
Dennis Bjorklund <db@zigo.dhs.org> writes:
> On Wed, 15 Jun 2005, Todd Landfried wrote:
>> NOTICE:  shared_buffers is 256

> This looks like it's way too low. Try something like 2048.

It also is evidently PG 7.2 or before; SHOW's output hasn't looked like
that in years.  Try a more recent release --- there's usually nontrivial
performance improvements in each major release.

            regards, tom lane

pgsql-performance by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: Needed: Simplified guide to optimal memory configuration
Next
From: Bruno Wolff III
Date:
Subject: Re: Needed: Simplified guide to optimal memory configuration