Hi Tomas,
Thanks so much for your response and sorry for not providing the enough
details.
I have attached the zip file which has query,explain plan and database
parameter settings for both primary and secondary.
Please note that query has multiple unions only the first query on top is
causing t
On 18.10.2013 23:49, sparikh wrote:
> Anybody has any idea, or pointer ? This is a high priority issue I
> have resolve at work. Any help would be of great help.
To help you we really need much more specific report. The one you posted
contains no details whatsoever - it doesn't even mention what v
On 15.10.2013 22:40, sparikh wrote:
> Hi, This is my first post ever in the Postgres forum. I am
> relatively new to Postgres and coming from oracle background.
>
> We have hot stand by setup to serve mainly the read only queries.
> Past few days we have been facing a performance issues on one of
http://www.postgresql.org/docs/current/static/hot-standby.html#HOT-STANDBY-CAVEATS
On Fri, Oct 18, 2013 at 11:49 PM, sparikh wrote:
> Anybody has any idea, or pointer ? This is a high priority issue I have
> resolve at work. Any help would be of great help.
>
>
>
> --
> View this message in co
Anybody has any idea, or pointer ? This is a high priority issue I have
resolve at work. Any help would be of great help.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Hot-Standby-performance-issue-tp5774673p5775103.html
Sent from the PostgreSQL - performance mailing
