Re: Cursor estimated row count - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Cursor estimated row count
Date
Msg-id 28801.1131821420@sss.pgh.pa.us
Whole thread Raw
In response to Cursor estimated row count  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Cursor estimated row count  (Michael Fuhr <mike@fuhr.org>)
List pgsql-hackers
Michael Fuhr <mike@fuhr.org> writes:
> An occasionally asked question is "How can I find out how many rows
> a cursor will return?" to which the answer is "Fetch them all."  But
> what about a way to get the planner's estimate?  Would anybody find
> that useful?

Given how far off it frequently is, I can't believe that any of the
people who ask for the feature would find this a satisfactory answer :-(
        regards, tom lane


pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: Cursor estimated row count
Next
From: Martijn van Oosterhout
Date:
Subject: Re: SIGSEGV taken on 8.1 during dump/reload