On Thu, Mar 8, 2012 at 4:43 AM, Ants Aasma <ants.aasma@xxxxxxxx> wrote: > On Wed, Mar 7, 2012 at 10:18 PM, Merlin Moncure <mmoncure@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
