fka...@googlemail.com: > I'll try to execute these tests on a SSD > and/or Raid system.
FYI: 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 14-16 MB/s. So, I conclude finally: (1) Postgresql write throughput (slowly) scales with the harddisk speed. (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! Felix -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
