On Thu, Mar 8, 2012 at 4:43 AM, Ants Aasma <ants.aasma@eesti.ee> wrote:
> On Wed, Mar 7, 2012 at 10:18 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
>> those numbers are stupendous for 8 drive sata. how much shared
>> buffers do you have?
>
> Couple of things to notice:
> 1) The benchmark can run fully in memory, although not 100% in shared_buffers.
> 2) These are 100k transaction runs, meaning that probably no
> checkpointing was going on.
> 3) Given the amount of memory in the server, with dirty flush
> settings the OS will do mostly sequential writes.
>
> Just ran a quick test. With synchronous_commit=off to simulate a BBU I
> have no trouble hitting 11k tps on a single SATA disk.
fsync=off might be a better way to simulate a BBU.
Cheers,
Jeff