I figured out how to speed up the sequential scans using "blockdev"
command. Essentially, this increases the read-ahead on the underlying
block device for the file system. It will change the read-ahead value
for the entire disk, even if there are several partitions on the disk.
The results are very promising. Unfortunately, I didn't take baseline
numbers and measure the effect with precision, but the look of it is
that things are much faster with the read-ahead set to 2048 instead of
the default 256. The read-ahead is measured in sectors read ahead by the
OS. The OS is Red Hat Linux, EL 5.5.
Sr. Oracle DBA
New York, NY 10036
The Leader in Integrated Media Intelligence Solutions
pgsql-novice by date
|Next:||From: Josh Kupershmidt||Date: 2010-09-14 22:04:30|
|Subject: Re: transaction is read-only error|
|Previous:||From: Salil Wadnerkar||Date: 2010-09-14 09:31:43|
|Subject: transaction is read-only error|