| From: | sparikh <sparikh(at)ecotality(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Hot Standby performance issue |
| Date: | 2013-10-22 00:00:45 |
| Message-ID: | 1382400045239-5775361.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> 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.
The EXPLAIN really should not do much I/O. I doubt it has anything to do
with fragmentation, so I doubt this is going to help.
Actually I was referring to this in the context of addressing main
underlying performance issue, not EXPLAIN. Sorry, I may not have
communicated it correctly.
Even strance does not seem to be installed.
The filesytem type it shows to me ext3.
Thanks.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Hot-Standby-performance-issue-tp5774673p5775361.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2013-10-22 04:49:24 | Re: Hot Standby performance issue |
| Previous Message | Tomas Vondra | 2013-10-21 23:14:42 | Re: Hot Standby performance issue |