Re: [PERFORM] Benchmarking tools, methods

2011-11-28 Thread CSS
On Nov 19, 2011, at 11:21 AM, Greg Smith wrote: > On 11/18/2011 04:55 AM, CSS wrote: >> I'm also curious about benchmarking using my own data. I tried something >> long ago that at least gave the illusion of working, but didn't seem quite >> right to me. I enabled basic query logging on one of

Re: [PERFORM] Benchmarking tools, methods

2011-11-19 Thread Greg Smith
On 11/18/2011 04:55 AM, CSS wrote: I'm also curious about benchmarking using my own data. I tried something long ago that at least gave the illusion of working, but didn't seem quite right to me. I enabled basic query logging on one of our busier servers, dumped the db, and let it run for 24

Re: [PERFORM] Benchmarking tools, methods

2011-11-18 Thread Scott Marlowe
On Fri, Nov 18, 2011 at 2:55 AM, CSS wrote: > ps - considering the new PostgreSQL Performance book that Packt has, any > strong feelings about that one way or the other?  Does it go very far beyond > what's on the wiki? Since others have provided perfectly good answers to all your other questi

Re: [PERFORM] Benchmarking tools, methods

2011-11-18 Thread Cédric Villemain
2011/11/18 Tomas Vondra : > On 18 Listopad 2011, 10:55, CSS wrote: >> Hello, >> >> I'm going to be testing some new hardware (see >> http://archives.postgresql.org/pgsql-performance/2011-11/msg00230.php) and >> while I've done some very rudimentary before/after tests with pgbench, I'm >> looking to

Re: [PERFORM] Benchmarking tools, methods

2011-11-18 Thread Tomas Vondra
On 18 Listopad 2011, 10:55, CSS wrote: > Hello, > > I'm going to be testing some new hardware (see > http://archives.postgresql.org/pgsql-performance/2011-11/msg00230.php) and > while I've done some very rudimentary before/after tests with pgbench, I'm > looking to pull more info than I have in the

[PERFORM] Benchmarking tools, methods

2011-11-18 Thread CSS
Hello, I'm going to be testing some new hardware (see http://archives.postgresql.org/pgsql-performance/2011-11/msg00230.php) and while I've done some very rudimentary before/after tests with pgbench, I'm looking to pull more info than I have in the past, and I'd really like to automate things