Ayub Khan <ayub.hp@gmail.com> writes:
> Is there any setting which needs to be modified to improve the performance
> of cursors. Also facing slow response with reading blobs (images) from db.
> Not an ideal way for storing images in db but this is a legacy application
> and wanted to check if there a quick tweak which can improve the
> performance while reading blob data from db.
Possibly twiddling cursor_tuple_fraction would help. The default setting
tends to encourage fast-start plans, which might be counterproductive
if you're always fetching the entire result in one go.
regards, tom lane