I am currently working on a project that has to retrieve large amounts of
data and returns it a piece at a time. This seems like an ideal
case for cursors. However, are their any downsides to using cursors? I hear
that each cursor will lock a postgresql backend process, is this true? As
I could have potentially have numerous of these queries being generated
that would be a major performance problem.
Any insight would be appreciated,
Mike