[PERFORM] stored procedure suddenly runs slowly in HOT STANDBY but fast in primary

We have two database servers running streaming replication between them: Primary server == OS: Linux version 2.6.18-371.3.1.el5 PostgreSQL: 9.1.11 HOT standby server == OS: Linux version 2.6.32-431.11.2.el6.x86_64 PostgreSQL: 9.1.11 Since July 1, one SP suddenly runs

[PERFORM] Re: stored procedure suddenly runs slowly in HOT STANDBY but fast in primary

Hi Tom, Thanks for your reply. As you said, the weirdest part is the the SP ran fine in primary server and hot standby server. I did another test over the weekend: (1) restore the production DB dump to an internal server with replication set up. (2) ran the SP in internal hot standy DB (3) surpri