Ayub Khan <ayub.hp@xxxxxxxxx> 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
