[HACKERS] Cursor estimated row count

2005-11-12 Thread Michael Fuhr
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? Does the code below look close to being correct? test= EXPLAIN SELECT * FROM

Re: [HACKERS] Cursor estimated row count

2005-11-12 Thread Tom Lane
Michael Fuhr [EMAIL PROTECTED] 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

Re: [HACKERS] Cursor estimated row count

2005-11-12 Thread Michael Fuhr
On Sat, Nov 12, 2005 at 01:50:20PM -0500, Tom Lane wrote: Michael Fuhr [EMAIL PROTECTED] 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