Postgres Pro
Downloads
Home   >   mailing lists

Re: driving postgres to achieve benchmark results similar to bonnie++ - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: driving postgres to achieve benchmark results similar to bonnie++
Date
Msg-id CACjxUsOxeLuSJ8+DKuqqtxe8Z3mKDBjQrYnkdZ4za9zzaV+dYg@mail.gmail.com
Whole thread Raw
In response to Re: driving postgres to achieve benchmark results similar to bonnie++  (Mike Broers <mbroers@gmail.com>)
Responses Re: driving postgres to achieve benchmark results similar to bonnie++
List pgsql-admin
Tree view 
On Tue, May 10, 2016 at 2:02 PM, Mike Broers <mbroers@gmail.com> wrote:

> If someone has an idea for how to set up pgbench to
> really push the io to prove out ssd potential, or a different
> script/approach that would be awesome.

You might want to play with some large effective_io_concurrency
settings, starting around 256.

http://www.postgresql.org/message-id/CAHyXU0yiVvfQAnR9cyH=HWh1WbLRsioe=mzRJTHwtr=2azsTdQ@mail.gmail.com

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Memory and Swap
Next
From: Bruce Momjian
Date:
Subject: Re: Major Version Upgradation in Replication Environment