Re: Needed: Simplified guide to optimal memory configuration

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
Cc: Todd Landfried <tlandfried(at)viatornetworks(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Needed: Simplified guide to optimal memory configuration
Date: 2005-06-15 14:18:25
Message-ID: 2608.1118845105@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dennis Bjorklund <db(at)zigo(dot)dhs(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-15 14:19:49 Re: Needed: Simplified guide to optimal memory configuration
Previous Message Dennis Bjorklund 2005-06-15 09:25:37 Re: Needed: Simplified guide to optimal memory configuration