Re: Best COPY Performance

Merlin,

On 10/25/06 8:38 AM, "Merlin Moncure" <mmoncure@gmail.com> wrote:

> in theory, with 10 10k disks in raid 10, you should be able to keep
> your 2fc link saturated all the time unless your i/o is extremely
> random.  random i/o is the wild card here, ideally you should see at
> least 2000 seeks in bonnie...lets see what comes up.

The 2000 seeks/sec are irrelevant to Postgres with one user doing COPY.
Because the I/O is single threaded, you will get one disk worth of seeks for
one user, roughly 150/second on a 10K RPM drive.

I suspect the problem here is the sequential I/O rate - let's wait and see
what the dd test results look like.

- Luke