On Wed, Apr 06, 2005 at 01:18:29PM -0400, Rod Taylor wrote: > Yeah, I think that can be done provided there is more than one worker. > My limit seems to be about 1000 transactions per second each with a > single insert for a single process (round trip time down the Fibre > Channel is large) but running 4 simultaneously only drops throughput to > about 900 per process (total of 2400 transactions per second) and the > machine still seemed to have lots of oomph to spare.
Erm, have I missed something here? 900 * 4 = 2400? /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
