Re: Load testing across 2 machines

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Gavin Hamill <gdh(at)laterooms(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Load testing across 2 machines
Date: 2006-04-09 16:00:14
Message-ID: 1144598414.21409.109.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-04-09 16:01:28 Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )
Previous Message Tom Lane 2006-04-09 15:56:08 Re: Create database bug in 8.1.3 ? -> solved