Re: driving postgres to achieve benchmark results similar to bonnie++

From: Kevin Grittner <kgrittn(at)gmail(dot)com>
To: Mike Broers <mbroers(at)gmail(dot)com>
Cc: Scott Whitney <scott(at)journyx(dot)com>, John Scalia <jayknowsunix(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: driving postgres to achieve benchmark results similar to bonnie++
Date: 2016-05-10 20:24:31
Message-ID: CACjxUsOxeLuSJ8+DKuqqtxe8Z3mKDBjQrYnkdZ4za9zzaV+dYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, May 10, 2016 at 2:02 PM, Mike Broers <mbroers(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2016-05-10 20:39:01 Re: Major Version Upgradation in Replication Environment
Previous Message Campbell, Lance 2016-05-10 20:23:16 Memory and Swap