Postgres Pro
Downloads
Home   >   mailing lists

Re: testing HS/SR - 1 vs 2 performance - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: testing HS/SR - 1 vs 2 performance
Date
Msg-id 4BC404B3.2080300@enterprisedb.com
Whole thread Raw
In response to Re: testing HS/SR - 1 vs 2 performance  ("Erik Rijkers" <er@xs4all.nl>)
Responses Re: testing HS/SR - 1 vs 2 performance  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Tree view 
I could reproduce this on my laptop, standby is about 20% slower. I ran
oprofile, and what stands out as the difference between the master and
standby is that on standby about 20% of the CPU time is spent in
hash_seq_search(). The callpath is GetSnapshotDat() ->
KnownAssignedXidsGetAndSetXmin() -> hash_seq_search(). That explains the
difference in performance.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: "Murali M. Krishna"
Date:
Subject: Re: debugger question
Next
From: Tom Lane
Date:
Subject: Re: non-reproducible failure of random test on HEAD