[GENERAL] Load Testing

2009-02-13 Thread Abdul Rahman
Hi all, Can any body tell me about tool for PostgreSQL load testing preferably freeware. Regards, Abdul Rehman.

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

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

Re: [GENERAL] Load Testing

2009-02-13 Thread Scott Marlowe
On Fri, Feb 13, 2009 at 4:48 AM, Ashish Karalkar ashis...@synechron.com 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 looks

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 -

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

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 of

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

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

[GENERAL] Load testing across 2 machines

2006-04-08 Thread Gavin Hamill
Hi, I'm asking here in case this kind of thing has been done before, but I've not been able to find it.. We have two pg 8.1.3 servers, one live and one test. What I'd like to do is have something like pgpool to act as a connection broker, but instead of using pgpool's own replication where all

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

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 system