Timeline for Slow query on primary server runs fast on hot standby
Current License: CC BY-SA 3.0
3 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jul 20, 2016 at 18:53 | comment | added | sudokai | The solution that worked in the end was creating the modified index. I tried changing the statistics setting, but that didn't produce any results. Setting enable_seqscan to false didn't force the query planner to use the alternative plan either. | |
Jul 20, 2016 at 18:50 | vote | accept | sudokai | ||
Jul 18, 2016 at 20:14 | history | answered | jjanes | CC BY-SA 3.0 |