> > There is no way for the backend to know this, thus imho the app needs > > to give a hint. > > Right. So what do you think about a hint that takes the form of a SET > variable for the fetch percentage to assume for a DECLARE CURSOR? Since we don't have other hints that are embedded directly into the SQL that sounds perfect. The not so offhand question for me is whether to use this percentage for non cursor selects also. Imho both should (at least in default) behave the same. Andreas
- Re: AW: AW: [HACKERS] LIMIT in DECLARE CURSOR: requ... Zeugswetter Andreas SB