Tom, all:
> Also, have you tried watching vmstat or local equivalent to confirm that
> the machine's not starting to swap?
We're not swapping.
> Josh, what sort of workload is being tested here --- read-mostly,
> write-mostly, a mixture?
It's a TPCC-like workload, so heavy single-row updates, and the
updates/inserts are what's being measured. For that matter, when I've seen
this before it was with heavy-write workloads and we were measuring the
number of updates/inserts and not the number of reads.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco