[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

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

piuschan writes: > PostgreSQL: 9.1.11 > Since July 1, one SP suddenly runs slowly in HOT STANDBY server. After > investigation, I can narrow the problem to one particular query in SP. >SELECT MIN(locate_id) INTO v_min_locate_id >FROM event_startstop >WHERE beacon_id = p_beacon_id