I'm motivated to contribute a patch for that. I would prefer to make tuple_fraction for cursors configurable as GUC parameter cursor_tuple_fraction. Do you agree with that? Regards, Robert -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Mittwoch, 02. April 2008 00:24 To: Hell, Robert Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Cursors and different settings for default_statistics_target "Hell, Robert" <Robert.Hell@xxxxxxxxxxxx> writes: > But why are the first 15 fetches (15360 rows) processed in 0.5 seconds and the last fetch (998 rows) takes 7 seconds. > Are we just unlucky that the last fetch takes that long? Well, the indexscan plan is going to scan through all the rows in objid order and return whichever of them happen to match the IN list. So I think you're just saying that your IN list isn't uniformly dense through the whole set of objids. If the real story is that you tend to select only objids within a narrow range, adding explicit "AND objid >= x AND objid <= y" constraints (where you compute x and y on the fly from the set of objids you're asking for) would reduce the overhead of the indexscan. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
