Skip site navigation (1) Skip section navigation (2)

Re: How to measure IO performance?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Andre Brandt" <brandt(at)decoit(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to measure IO performance?
Date: 2008-09-09 18:14:37
Message-ID: dcc563d10809091114p388fa092la8f7362eb203fd20@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Sep 9, 2008 at 7:59 AM, Andre Brandt <brandt(at)decoit(dot)de> wrote:
> Hi out there,
>
> I've some little questions, perhaps you can help me...
>
> So in order to get rid of wait I/O (as far as possible), we have to
> increase the I/O performance. Because of there are a lot storage systems
> out there, we need to know how many I/O's per second we actually need.
> (To decide, whether a storage systems can handle our load or a bigger
> system is required. )  Do you have some suggestions, how to measure that?
> Do you have experience with postgres on something like HP MSA2000(10-20
> disks) or RamSan systems?

Generally the best bang for the buck is with Direct Attached Storage
system with a high quality RAID controllers, like the 3Ware or Areca
or LSI or HPs 800 series.  I've heard a few good reports on higher end
adaptecs, but most adaptec RAID controllers are pretty poor db
performers.

To get an idea of how much I/O you'll need, you need to see how much
you use now.  A good way to do that is to come up with a realistic
benchmark and run it at a low level of concurrency on your current
system, while running iostat and / or vmstat in the background.
pidstat can be pretty useful too.  Run a LONG benchmark so it averages
out, you don't want to rely on a 5 minute benchmark.  Once you have
some base numbers, increase the scaling factor (i.e. number of threads
under test) and measure I/O and CPU etc for that test.

Now, figure out how high a load factor you'd need to run your full
load and multiply that times your 1x benchmark's I/O numbers, plus a
fudge factor or 2 to 10 times for overhead.

The standard way to hand more IO ops per second is to add spindles.
It might take more than one RAID controller or external RAID enclosure
to meet your needs.

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2008-09-09 20:26:55
Subject: Re: PostgreSQL TPC-H test result?
Previous:From: Andrew SullivanDate: 2008-09-09 15:51:13
Subject: Re: PostgreSQL TPC-H test result?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group