[PERFORM] Postgres benchmarking with pgbench

2009-03-16 Thread m...@bortal.de
Hello List, i would like to pimp my postgres setup. To make sure i dont have a slow hardware, i tested it on three diffrent enviorments: 1.) Native Debian Linux (Dom0) and 4GB of RAM 2.) Debian Linux in Xen (DomU) 4GB of RAM 3.) Blade with SSD Disk 8GB of RAM Here are my results: http://i39.ti

Re: [PERFORM] Postgres benchmarking with pgbench

2009-03-19 Thread m...@bortal.de
i do, the graph looks the same. Any hints or tips what my config should look like? Or are these results even okay? Maybe i am driving myself crazy for nothing? Cheers, Mario Greg Smith wrote: On Mon, 16 Mar 2009, m...@bortal.de wrote: Any idea why my performance colapses at 2GB Dat

[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?