On Wed, 2006-08-16 at 10:24 -0400, John R. Allgood wrote: > I am needing to determine the tps for a production application > running on PostgreSQL 7.4.7. I know you can use pg_bench and create a > new database to determine an estimate of tps. Is there a way I can get > this info out of my production database. > Look in the pg_stat_database or pg_stat_get_db_xact_commit(oid) (where oid is the oid of the database). This number is reset when the statistics are reset, so it may not be the number of transactions since the database was created. But you can use it to test TPS easily. Regards, Jeff Davis
