|
On 2010-10-21 06:47, Scott Carey wrote: > On a wimpy disk, I/O bound for sure. But my disks go 1000MB/sec. > No query can go fast enough for them. The best I've gotten is > 800MB/sec, on a wide row (average 800 bytes). Most tables go > 300MB/sec or so. And with 72GB of RAM, many scans are in-memory > anyway. Is it cpu or io bound while doing it?Can you scan it faster using time cat relation-oid.* > /dev/null > A single SSD with supercapacitor will go about 500MB/sec by itself > next spring. I will easily be able to build a system with 2GB/sec > I/O for under $10k. What filesystem are you using? Readahead? Can you try to check the filesystemfragmentation of the table using filefrag? -- Jesper |
