From: dforums <dforums@vieonet.com>
To: Erik Jones <erik@myemma.com>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimisation help
Date: Wed, 05 Mar 2008 09:18:19 +0100
Message-ID: <47CE574B.3000703@vieonet.com> (raw)
In-Reply-To: <82845731-D41C-4A79-9937-4A03CF455B36@myemma.com>
References: <47CDCB62.9070302@vieonet.com>
<Pine.GSO.4.64.0803041743060.22870@westnet.com>
<47CDEF5B.8080905@vieonet.com>
<82845731-D41C-4A79-9937-4A03CF455B36@myemma.com>
OK I found the cause, it was a default settings added on server start.
(-B 1024) Grrrrrrrrr!!!!!
Now it works really better I devide the full time per 2.
I suppose I steal have to look deep in the procedure to see some hack,
has somebody suggest, I will try to buffer all updates in one.
One question, Could I optimise the treatment if I'm doing the select on
a view while updating the main table ????
regards
David
Erik Jones a écrit :
>
> 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@myemma.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
>
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dforums@vieonet.com, erik@myemma.com, gsmith@gregsmith.com
Subject: Re: Optimisation help
In-Reply-To: <47CE574B.3000703@vieonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox