Re: FW: - Mailing list pgsql-performance

From Gregory Stark
Subject Re: FW:
Date
Msg-id 87d51ai5zg.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: FW:  (david@lang.hm)
List pgsql-performance
<david@lang.hm> writes:

> with a standard 7200 rpm drive ~150 transactions/sec sounds about right
>
> to really speed things up you want to get a disk controller with a battery
> backed cache so that the writes don't need to hit the disk to be safe.

Note that this is only if you're counting transactions/sec in a single
session. You can get much more if you have many sessions since they can all
commit together in a single disk i/o.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Next
From: Peter Eisentraut
Date:
Subject: Re: Nested loops overpriced