Re: [GENERAL] Load testing across 2 machines

2006-04-10 Thread Richard Huxton
Gavin Hamill wrote: On Sun, 09 Apr 2006 17:00:14 +0100 Simon Riggs <[EMAIL PROTECTED]> wrote: Sniff the live log for SELECT statements (plus their live durations), Wow, how wonderfully low-tech - hence it's right up my street :) Yay, some tail + psql fun coming up! Be careful though - concu

Re: [GENERAL] Load testing across 2 machines

2006-04-09 Thread Gavin Hamill
On Sun, 09 Apr 2006 17:00:14 +0100 Simon Riggs <[EMAIL PROTECTED]> wrote: > On Sat, 2006-04-08 at 15:10 +0100, Gavin Hamill wrote: > > > SELECTS go to *both* live and test, but only the answers from live > > are sent back to clients - the answers from test are discarded... > > Put log_min_durat

Re: [GENERAL] Load testing across 2 machines

2006-04-09 Thread Joshua D. Drake
Gavin Hamill wrote: On Sun, 09 Apr 2006 17:00:14 +0100 Simon Riggs <[EMAIL PROTECTED]> wrote: Sniff the live log for SELECT statements (plus their live durations), Wow, how wonderfully low-tech - hence it's right up my street :) Yay, some tail + psql fun coming up! You can even tell it to o

Re: [GENERAL] Load testing across 2 machines

2006-04-09 Thread Gavin Hamill
On Sun, 09 Apr 2006 17:00:14 +0100 Simon Riggs <[EMAIL PROTECTED]> wrote: > Sniff the live log for SELECT statements (plus their live durations), Wow, how wonderfully low-tech - hence it's right up my street :) Yay, some tail + psql fun coming up! Cheers, Gavin. ---(end

Re: [GENERAL] Load testing across 2 machines

2006-04-09 Thread Simon Riggs
On Sat, 2006-04-08 at 15:10 +0100, Gavin Hamill wrote: > SELECTS go to *both* live and test, but only the answers from live are > sent back to clients - the answers from test are discarded... Put log_min_duration_statement = 0 so all SELECTs go to the log. Sniff the live log for SELECT statemen