Peter Alban <peter.alban2@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
