Re: [GENERAL] select vs cursor/fetch speed disparity

2011-10-10 Thread Bosco Rama
Bosco Rama wrote: > Tom Lane wrote: >> >> Cursors are biased towards fast-start plans on the theory that you >> may not be intending to fetch the whole result. Queries with ORDER BY >> and/or LIMIT are particularly likely to see plan changes as a >> consequence of that. In 8.4 and up you can fro

Re: [GENERAL] select vs cursor/fetch speed disparity

2011-10-10 Thread Bosco Rama
Hi Tom, Tom Lane wrote: > Bosco Rama writes: >> I have a strange disparity between a query that is run as a >> straight select and the same query via a cursor. I hope I can >> jog someone's memory with the description as I have been unable >> to create a sanitized and/or reduced data set & schem

Re: [GENERAL] select vs cursor/fetch speed disparity

2011-10-07 Thread Tom Lane
Bosco Rama writes: > I have a strange disparity between a query that is run as a > straight select and the same query via a cursor. I hope I can > jog someone's memory with the description as I have been unable > to create a sanitized and/or reduced data set & schema that will > reproduce this ..