Re: Best COPY Performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Merlin,

On 10/25/06 8:38 AM, "Merlin Moncure" <mmoncure@xxxxxxxxx> 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




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux