Postgres Pro
Downloads
Home   >   mailing lists

Re: Load testing across 2 machines - Mailing list pgsql-general

From Simon Riggs
Subject Re: Load testing across 2 machines
Date
Msg-id 1144598414.21409.109.camel@localhost.localdomain
Whole thread Raw
In response to Load testing across 2 machines  (Gavin Hamill <gdh@laterooms.com>)
Responses Re: Load testing across 2 machines  (Gavin Hamill <gdh@laterooms.com>)
Re: Load testing across 2 machines  (Gavin Hamill <gdh@laterooms.com>)
List pgsql-general
Tree view 
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 statements (plus their live durations),
then route those same statements to the dev box and get a timing from
there also. That way you'll be able to do this without any C coding,
plus you'll have both the live and test elapsed times as a comparison.

Best Regards, Simon Riggs

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Create database bug in 8.1.3 ? -> solved
Next
From: Tom Lane
Date:
Subject: Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )