Re: [PERFORM] current transaction in productive database

2009-03-20 Thread Euler Taveira de Oliveira
m...@bortal.de escreveu: > is there a way to find out, how many transactions my currenc productive > database is doing? > If you're looking for number of transactions then you can query the catalogs as: $ export myq="select sum(xact_commit+xact_rollback) from pg_stat_database" $ psql -U postgres

Re: [PERFORM] current transaction in productive database

2009-03-20 Thread Greg Smith
On Fri, 20 Mar 2009, m...@bortal.de wrote: is there a way to find out, how many transactions my currenc productive database is doing? What you probably want here is not a true transaction count, which might include thing that don't matter much for scaling purposes, but instead to count thing

Re: [PERFORM] current transaction in productive database

2009-03-20 Thread Jeff
On Mar 20, 2009, at 5:26 AM, m...@bortal.de wrote: Hello List, is there a way to find out, how many transactions my currenc productive database is doing? I know know how much i an offer with my new database and hardware, but i would also like to know what i actually _need_ on my current

[PERFORM] current transaction in productive database

2009-03-20 Thread m...@bortal.de
Hello List, is there a way to find out, how many transactions my currenc productive database is doing? I know know how much i an offer with my new database and hardware, but i would also like to know what i actually _need_ on my current productive system. Is there a way to find this out?