Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 6E5782E0070 for ; Tue, 1 Apr 2008 13:42:24 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00870-08 for ; Tue, 1 Apr 2008 13:42:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 83E6B2E002D for ; Tue, 1 Apr 2008 13:42:05 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m31Gg3AX010000; Tue, 1 Apr 2008 12:42:03 -0400 (EDT) To: "Hell, Robert" cc: pgsql-performance@postgresql.org Subject: Re: Cursors and different settings for default_statistics_target In-reply-to: References: <2798.1207063805@sss.pgh.pa.us> <9629.1207066619@sss.pgh.pa.us> Comments: In-reply-to "Hell, Robert" message dated "Tue, 01 Apr 2008 18:33:19 +0200" Date: Tue, 01 Apr 2008 12:42:03 -0400 Message-ID: <9999.1207068123@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/12 X-Sequence-Number: 29505 "Hell, Robert" writes: > That's CURSOR_OPT_FAST_PLAN and isn't it? Our application reads the full > results of most cursors. Just out of curiosity, why use a cursor at all then? But anyway, you might want to consider running a custom build with a higher setting for tuple_fraction for OPT_FAST_PLAN (look into planner.c). I've occasionally thought about exposing that as a GUC parameter, but never gotten motivated to do it. regards, tom lane