Re: [GENERAL] Load Testing

2009-02-13 Thread Scott Marlowe
On Fri, Feb 13, 2009 at 4:48 AM, Ashish Karalkar wrote: > Ashish Karalkar wrote: >> >> Abdul Rahman wrote: >>> >>> Hi all, >>> >>> Can any body tell me about tool for PostgreSQL load testing preferably >>> freeware. >>> >>> Regards, >>> Abdul Rehman. >>> >> I am not sure its a freeware or not but

Re: [GENERAL] Load Testing

2009-02-13 Thread Ashish Karalkar
Abdul Rahman wrote: Hi all, Can any body tell me about tool for PostgreSQL load testing preferably freeware. Regards, Abdul Rehman. I am not sure its a freeware or not but looks promising http://bristlecone.continuent.org/HomePage --Ashish -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] Load Testing

2009-02-13 Thread Ashish Karalkar
Ashish Karalkar wrote: Abdul Rahman wrote: Hi all, Can any body tell me about tool for PostgreSQL load testing preferably freeware. Regards, Abdul Rehman. I am not sure its a freeware or not but looks promising http://bristlecone.continuent.org/HomePage --Ashish And ofcourse the PGben

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

Re: [GENERAL] load testing

2004-03-10 Thread Steve Wolfe
> I wanted to do some quick load testing on a postgres database. Does anyone > have any tips on how to go about doing this? > Thanks much. Sure. Test after the manner in which the database is normally used, and with "real-world" data. I've seen far too many people "benchmark" a database sy

Re: [GENERAL] load testing

2004-03-10 Thread scott.marlowe
On Tue, 9 Mar 2004, Sally Sally wrote: > I wanted to do some quick load testing on a postgres database. Does anyone > have any tips on how to go about doing this? > Thanks much. If you just wanna beat the database a bit to test for reliability etc, look at contrib/pgbench in the distro. If you