From: | sparikh <sparikh(at)ecotality(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Hot Standby performance issue |
Date: | 2013-10-21 22:59:37 |
Message-ID: | 1382396377294-5775349.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Yes, Expalin without Analyze is taking long. It is weird. In the
pg_stat_activity Explain was the only query running. So server was almost
idle. Using New relic interface I checked CPU was almost idle - around
10-20%. There were some IO activity - around 40-50%.
I forgot to mention before I could run perf on command line even with root
permission. It says command not found. May be utility is not installed or
not enabled.
I have attached the snapshot of vmstat while explain was running in
background. vmstat.txt
<http://postgresql.1045698.n5.nabble.com/file/n5775349/vmstat.txt>
Do you suggest if I remove all the data files from /data/base folder of
standby and again rebuild using rsync from primary ? do you see any issues
there.? This is just to rule out any fragmentation on standby side.
Our sys admin is planning to run fsck sometime today or tomorrow.
Thanks.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Hot-Standby-performance-issue-tp5774673p5775349.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2013-10-21 23:14:42 | Re: Hot Standby performance issue |
Previous Message | Tomas Vondra | 2013-10-21 21:54:22 | Re: Hot Standby performance issue |