Re: Cursor estimated row count

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Cursor estimated row count
Дата
Msg-id 20051112185600.GA92075@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: Cursor estimated row count  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sat, Nov 12, 2005 at 01:50:20PM -0500, Tom Lane wrote:
> 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 :-(

That aside, do you see any problems with the code?  Is it at least
returning the right wrong answer? ;-)

-- 
Michael Fuhr


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SIGSEGV taken on 8.1 during dump/reload
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: CONNECT BY PRIOR