Peter Alban <peter(dot)alban2(at)gmail(dot)com> wrote:
> Why is there such a big difference ?
>
> i.e. off peek times a simple select with where (on indexed column)
> and limit taks* 40 ms* during peek times it took *2 seconds* - 50
> times slower !
If your high work_mem setting you may have been causing the OS to
discard cached data, causing disk reads where you normally get cache
hits, or even triggered swapping. Either of those can easily cause a
difference of that magnitude, or more.
-Kevin