Re: New to PostgreSQL, performance considerations - Mailing list pgsql-performance

From Michael Stone
Subject Re: New to PostgreSQL, performance considerations
Date
Msg-id 20061212123252.GR16692@mathom.us
Whole thread Raw
In response to Re: New to PostgreSQL, performance considerations  (Alexander Staubo <alex@purefiction.net>)
Responses Re: New to PostgreSQL, performance considerations
List pgsql-performance
On Tue, Dec 12, 2006 at 12:29:29PM +0100, Alexander Staubo wrote:
>I suspect the hardware's real maximum performance of the system is
>~150 tps, but that the LSI's write cache is buffering the writes. I
>would love to validate this hypothesis, but I'm not sure how.

With fsync off? The write cache shouldn't really matter in that case.
(And for this purpose that's probably a reasonable configuration.)

Mike Stone

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: Cosimo Streppone
Date:
Subject: Re: New to PostgreSQL, performance considerations