| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Erik Rijkers <er(at)xs4all(dot)nl> |
| Cc: | Simon Riggs <simon(at)2ndQuadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: testing HS/SR - 1 vs 2 performance |
| Date: | 2010-04-22 21:41:29 |
| Message-ID: | 4BD0C289.9090208@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Erik Rijkers wrote:
> This is the same behaviour (i.e. extreme slow standby) that I saw earlier (and which caused the
> original post, btw). In that earlier instance, the extreme slowness disappeared later, after many
> hours maybe even days (without bouncing either primary or standby).
>
Any possibility the standby is built with assertions turned out? That's
often the cause of this type of difference between pgbench results on
two systems, which easy to introduce when everyone is building from
source. You should try this on both systems:
psql -c "show debug_assertions"
just to rule that out.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2010-04-22 21:54:55 | Re: testing HS/SR - 1 vs 2 performance |
| Previous Message | Alvaro Herrera | 2010-04-22 21:14:00 | Re: Thoughts on pg_hba.conf rejection |