Re: Load testing across 2 machines

Поиск
Список
Период
Сортировка
Искать
От
Simon Riggs
Тема
Re: Load testing across 2 machines
Дата
Msg-id
1144598414.21409.109.camel@localhost.localdomain
Ответ на
Load testing across 2 machines (Gavin Hamill)
Список
Дерево обсуждения
Load testing across 2 machines Gavin Hamill <gdh@laterooms.com>
Re: Load testing across 2 machines Simon Riggs <simon@2ndquadrant.com>
Re: Load testing across 2 machines Gavin Hamill <gdh@laterooms.com>
Re: Load testing across 2 machines "Joshua D. Drake" <jd@commandprompt.com>
Re: Load testing across 2 machines Richard Huxton <dev@archonet.com>
Re: Load testing across 2 machines Gavin Hamill <gdh@laterooms.com> 
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 по дате отправления
Предыдущее
От: Tom Lane
Дата:
Следующее
От: Tom Lane
Дата:
FAQ