Tom,
> Well, if the load is a lot of short writing transactions then you'd
> expect the throughput to depend on how fast stuff can be pushed down to
> WAL. What have you got wal_buffers set to? Are you using a commit
> delay? What's the I/O system anyway (any BB write cache on the WAL
> disk?) and what wal sync method are you using?
You know, I think Jignesh needs to me on this list so I can stop relaying
questions on a workload I didn't design. Let me get him.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco