Re: AW: LIMIT in DECLARE CURSOR: request for comments - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AW: LIMIT in DECLARE CURSOR: request for comments
Date
Msg-id 6759.973267855@sss.pgh.pa.us
Whole thread Raw
In response to AW: LIMIT in DECLARE CURSOR: request for comments  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
> I did understand this, but I still disagree. Whether this is what you want
> strongly depends on what the application does with the resulting rows.

Sure ...

> 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?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Christof Petig
Date:
Subject: Re: AW: Re: [GENERAL] Query caching
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: AW: LIMIT in DECLARE CURSOR: request for comments