Am 21.05.2007 um 23:51 schrieb Greg Smith:
The standard pgbench transaction includes a select, an insert, and three updates.
I see. Didn't know that, but it makes sense.
Unless you went out of your way to turn it off, your drive is caching writes; every Seagate SATA drive I've ever seen does by default. "1062 tps with 3-4 clients" just isn't possible with your hardware otherwise.
Btw: it wasn't my hardware in this test! cug ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster