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