| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Ants Aasma <ants(dot)aasma(at)eesti(dot)ee> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, Craig James <cjames(at)emolecules(dot)com>, Rory Campbell-Lange <rory(at)campbell-lange(dot)net>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Advice sought : new database server |
| Date: | 2012-03-08 16:03:42 |
| Message-ID: | CAMkU=1wu-FNJaz6=cec47D9Y7P5OYXFb_fxX1BuLz_AMbJ-Pyg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Mar 8, 2012 at 4:43 AM, Ants Aasma <ants(dot)aasma(at)eesti(dot)ee> wrote:
> On Wed, Mar 7, 2012 at 10:18 PM, Merlin Moncure <mmoncure(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jochen Erwied | 2012-03-08 16:15:58 | Re: Advice sought : new database server |
| Previous Message | Rory Campbell-Lange | 2012-03-08 13:27:37 | Re: Advice sought : new database server |