Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 46E0CB5D91F for ; Fri, 19 Aug 2011 18:15:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 93849-10 for ; Fri, 19 Aug 2011 21:14:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id E2C90B5DBF6 for ; Fri, 19 Aug 2011 18:14:55 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1QuWOz-00073n-Fg for pgsql-performance@postgresql.org; Fri, 19 Aug 2011 14:14:53 -0700 Date: Fri, 19 Aug 2011 14:14:53 -0700 (PDT) From: hyelluas To: pgsql-performance@postgresql.org Message-ID: <1313788493468-4717048.post@n5.nabble.com> In-Reply-To: <00868fd1b178f824dd94d3f17b021953.squirrel@sq.gransy.com> References: <1313620811606-4710245.post@n5.nabble.com> <00868fd1b178f824dd94d3f17b021953.squirrel@sq.gransy.com> Subject: Re: tunning strategy needed MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.778 tagged_above=-10 required=5 tests=BAYES_00=-1.9, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201108/244 X-Sequence-Number: 44691 thank you, it is a great article. the current on 8.1 checkpoint_segments = 3. it looks too low for me , but I'm not tuning the 8.1 schema. I'm looking for a generic approach of improving that beast while moving it to 8.4 I'm trying to understand the internals for Views vs. Functions there was none on 8.1 and I'm using pgpsql for 8.4. Does it make sence to put view's sql into a function? would it save on re-creating the execution plan and parsing? thank you. Helen -- View this message in context: http://postgresql.1045698.n5.nabble.com/tunning-strategy-needed-tp4710245p4717048.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.