Re: testing HS/SR - 1 vs 2 performance
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Erik Rijkers" <er@xs4all.nl>
Cc: "Simon Riggs" <simon@2ndquadrant.com>, "Robert Haas" <robertmhaas@gmail.com>, "Heikki Linnakangas" <heikki.linnakangas@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2010-04-25T18:55:02Z
Lists: pgsql-hackers
"Erik Rijkers" <er@xs4all.nl> writes: > FWIW, here are some more results from pgbench comparing > primary and standby (both with Simon's patch). That seems weird. Why do most of the runs show primary and standby as having comparable speed, but a few show the standby as much slower? The parameters for those runs don't seem obviously different from cases where it's fast. I think there might have been something else going on on the standby during those runs. Or do you think those represent cases where the mystery slowdown event happened? regards, tom lane