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.
In response to
pgsql-performance by date
|Next:||From: Bryce Ewing||Date: 2009-06-18 22:11:25|
|Subject: Re: Index Scan taking long time|
|Previous:||From: Peter Alban||Date: 2009-06-18 20:49:55|
|Subject: Re: Strange performance response for high load times|