Re: GUC parameter cursors_tuple_fraction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hell, Robert" <Robert(dot)Hell(at)fabasoft(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: GUC parameter cursors_tuple_fraction
Date: 2008-05-02 21:28:31
Message-ID: 25502.1209763711@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Hell, Robert" <Robert(dot)Hell(at)fabasoft(dot)com> writes:
> This patch adds a GUC parameter for tuple_fraction of cursors (discussed
> earlier here:
> http://archives.postgresql.org/pgsql-performance/2008-04/msg00018.php)
> By setting this parameter the planner's favor to use fast-start plans
> for cursors can be affected.

Applied with some documentation cleanup, and also care for the behavior
at the range endpoints 0 and 1. A user expecting it to act like a
simple fraction would have been quite surprised at the endpoints
(see the header comments for grouping_planner).

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-05-02 21:43:26 Re: Protection from SQL injection
Previous Message Jan Urbański 2008-05-02 21:22:55 VacAttrStatsP vs VacAttrStats * (typedef'ing pointer types)

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2008-05-02 22:18:29 Re: [COMMITTERS] pgsql: Sigh ...
Previous Message Tom Lane 2008-05-02 21:13:38 Re: [HACKERS] GUC parameter cursors_tuple_fraction