On Mon, 2008-01-21 at 18:31 -0500, Greg Smith wrote: > pgbench doesn't handle 100 clients at once very well on the same box as > the server, unless you have a pretty serious system. The pgbench program > itself has a single process model that doesn't handle the CFQ round-robin > very well at all. On top of that, the database scale should be bigger He was referring to the CFQ I/O scheduler. I don't think that will affect pgbench itself, because it doesn't read/write to disk, right? Regards, Jeff Davis ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster