Some numbers that indicate PostgreSQL performance using JDBC to query and insert data. All of the tests done on the same quiescent machine.
...
Switching off fsync and full_page_writes has no effect on performance.
Similar checks on Oracle
Writing the same in Oracle is quite a lot faster. Without indexes and PK, but with full transaction logging the performance is:
- Inserted 1000000 rows in 1072 milliseconds, 1000000.0 rows per second
- Inserted 24000000 rows in 47155 milliseconds, 510638.2978723404 rows per second