Re: raid array seek performance - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: raid array seek performance
Date
Msg-id CAHyXU0zGOKhY3H_giqz2=39cLzGccFwVYnS7Ag9coiWpt0RKMQ@mail.gmail.com
Whole thread Raw
In response to Re: raid array seek performance  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-performance
On Wed, Sep 14, 2011 at 2:44 AM, Greg Smith <greg@2ndquadrant.com> wrote:
> If you want to get a useful measurement of seeks/second, setup pgbench-tools
> with a SELECT-only test, and create a database that's 2 to 4X as big as RAM.
>  The TPS result you get from that is a much more useful number for
> real-world seeks than this.

A thought on that note: it sure would be nice if you could define
scaling factor in terms of data size instead of linear multiples of
100000, something like:

pgbench -i -x 64gb

merlin

pgsql-performance by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: cannot use multicolumn index
Next
From: "Igor Neyman"
Date:
Subject: Re: Migrated from 8.3 to 9.0 - need to update config (re-post)