From: | dforums <dforums(at)vieonet(dot)com> |
---|---|
To: | Erik Jones <erik(at)myemma(dot)com> |
Cc: | Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Optimisation help |
Date: | 2008-03-05 08:18:19 |
Message-ID: | 47CE574B.3000703@vieonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(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
>
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Moritz Onken | 2008-03-05 08:54:35 | Re: PostgreSQL performance on a virtual host |
Previous Message | dforums | 2008-03-05 00:54:51 | Re: Optimisation help |