Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 86BBA2E00E8 for ; Wed, 5 Mar 2008 04:25:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 98529-05 for ; Wed, 5 Mar 2008 04:25:09 -0400 (AST) X-Greylist: delayed 00:06:40.861281 by SQLgrey-1.7.5 Received: from 26.mail-out.ovh.net (26.mail-out.ovh.net [91.121.27.225]) by postgresql.org (Postfix) with SMTP id 939AA2E00E3 for ; Wed, 5 Mar 2008 04:25:12 -0400 (AST) Received: (qmail 24523 invoked by uid 503); 5 Mar 2008 08:18:52 -0000 Received: (QMFILT: 1.0); 05 Mar 2008 08:18:52 -0000 Received: from b7.ovh.net (HELO mail153.ha.ovh.net) (213.186.33.57) by 26.mail-out.ovh.net with SMTP; 5 Mar 2008 08:18:52 -0000 Received: from b0.ovh.net (HELO queue-out) (213.186.33.50) by b0.ovh.net with SMTP; 5 Mar 2008 08:18:32 -0000 Received: from ita73-1-82-239-31-94.fbx.proxad.net (HELO localhost.localdomain) (dforums@vieonet.com@82.239.31.94) by ns0.ovh.net with SMTP; 5 Mar 2008 08:18:29 -0000 Message-ID: <47CE574B.3000703@vieonet.com> Date: Wed, 05 Mar 2008 09:18:19 +0100 From: dforums User-Agent: Thunderbird 2.0.0.12 (X11/20080226) MIME-Version: 1.0 To: Erik Jones CC: Greg Smith , pgsql-performance@postgresql.org Subject: Re: Optimisation help References: <47CDCB62.9070302@vieonet.com> <47CDEF5B.8080905@vieonet.com> <82845731-D41C-4A79-9937-4A03CF455B36@myemma.com> In-Reply-To: <82845731-D41C-4A79-9937-4A03CF455B36@myemma.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Ovh-Remote: 82.239.31.94 (ita73-1-82-239-31-94.fbx.proxad.net) X-Ovh-Local: 213.186.33.20 (ns0.ovh.net) X-Spam-Check: DONE|H 0.5/N X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/67 X-Sequence-Number: 29021 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 > > >