Robert Haas wrote: > I suppose one interesting question is to figure out if there's a way I > can optimize the disk configuration in this machine, or the Linux I/O > scheduler, or something, so as to reduce the amount of time it spends > waiting for the disk.
I'd be curious to know if using the deadline scheduler will improve things. I have experienced pretty bad performance with cfq under load, where sequential table scans were starved to the point where they took hours instead of less than a minute (on an idle system). But I believe that also depends a lot on the storage system used. Yours, Laurenz Albe -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers