Javier Reyes <c.javier.reyes.e@xxxxxxxxx> writes: > I have a server with 4GB of RAM and PostgreSQL 9.0.3 on Centos 5. I'm using > pgbench and pgbench-tools to measure performance, using two pgbench-tools > queries: select and tpc-b. > With default settings of postgresql.conf and select query, I get the > following results: > Scale: 1, 10, 100, 1000. > Transactions per second: 10000, 8800, 7500, 100. These numbers look like complete junk from here. I suspect you were using a number-of-transactions parameter that's too small to give stable answers. If you don't have the value set high enough so that each pgbench run lasts at least a couple of minutes, I wouldn't put any credence in the results. See also the other "good practices" mentioned at the bottom of the pgbench documentation page. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
