Re: Réf - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Réf
Date
Msg-id 20050406174254.GC13641@uio.no
Whole thread Raw
In response to Re: Réf. : Re: RE : RE: Postgresql  (Rod Taylor <pg@rbt.ca>)
Responses Re: Réf
List pgsql-performance
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/

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Plan for relatively simple query seems to be very inefficient
Next
From: "Dave Held"
Date:
Subject: Re: Plan for relatively simple query seems to be very inefficient