Re: slow performance with cursor

Ayub Khan <ayub(dot)hp(at)gmail(dot)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