top - 10:18:58 up 224 days, 15:10, 2 users, load average: 6.27, 7.33, 6 Tasks: 239 total, 1 running, 238 sleeping, 0 stopped, 0 zombie Cpu(s): 5.0%us, 0.7%sy, 0.0%ni, 61.5%id, 32.7%wa, 0.0%hi, 0.1%si, 0 Mem: 32962804k total, 32802612k used, 160192k free, 325360k buffers Swap: 8193140k total, 224916k used, 7968224k free, 30829456k cached Didn't really see the pattern, typical the cpu load is only about 40% On Mon, Jun 29, 2009 at 7:26 PM, Mike Ivanov<mikei@xxxxxxxxxxxxxxx> wrote: > Hi Sean, > > Sean Ma wrote: >> >> One months ago, this type of slow query happened about a few time per >> day. But recently, the slow query happens more frequent at the rate of >> once every 10 minutes or less. There seesm not relation to th > > What is your hardware (memory, CPU type and such)? > > This seems like a cache issue to me, but I can't tell for sure without some > additional information on your system: > > 1) What is the amount of a) available memory b) free memory and c) memory > available to i/o buffers? > > 2) What is the swap usage if any? > > 3) What is the CPU load? Any noticeable patterns in CPU load? > > You can use /usr/bin/top to obtain most of this information. > > Mike > > > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
