Re: Optimisation help

From: Erik Jones <erik(at)myemma(dot)com>
To: dforums <dforums(at)vieonet(dot)com>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimisation help
Date: 2008-03-05 00:19:32
Message-ID: 82845731-D41C-4A79-9937-4A03CF455B36@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Mar 4, 2008, at 6:54 PM, dforums wrote:

> Hello,
>
> After controling the settings I so, that shared_buffers is
> configurated at 1024 (the default), however, in my postgresql.conf I
> set it to 250000, is it due to shared memory settings, should I
> increase shmmax?

Did you do a full restart of the db cluster? Changes to shared memory
settings require that.

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message dforums 2008-03-05 00:37:44 Re: Optimisation help
Previous Message dforums 2008-03-05 00:15:25 Re: Optimisation help