> I'll try to execute these tests on a SSD
> and/or Raid system.
On a sata raid-0 (mid range hardware) and recent 2x 1.5 TB
disks with a write performance of 100 MB/s (worst, to 200
MB/s max), I get a performance of 18.2 MB/s. Before, with
other disk 43 MB/s (worst to 70 MB/s max) postgres came to
So, I conclude finally:
(1) Postgresql write throughput (slowly) scales with the
(2) The throughput (not counting WAL doubling data) in
postgresql is 20-25% of the disk thoughput.
I want to thank you all for the very good support!
In response to
pgsql-performance by date
|Next:||From: firstname.lastname@example.org||Date: 2010-01-19 10:50:07|
|Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?|
|Previous:||From: Ing. Marcos L. Ortiz Valmaseda||Date: 2010-01-19 08:25:28|
|Subject: Re: renice on an I/O bound box|