On Wed, Sep 14, 2011 at 2:44 AM, Greg Smith <greg@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance