Re: Getting Slow
От | Andrew Sullivan |
---|---|
Тема | Re: Getting Slow |
Дата | |
Msg-id | 20070607183748.GL14087@phlogiston.dyndns.org обсуждение исходный текст |
Ответ на | Getting Slow (Joe Lester <joe_lester@sweetwater.com>) |
Список | pgsql-performance |
On Thu, Jun 07, 2007 at 01:48:43PM -0400, Joe Lester wrote: > of a table). Running the same query 4 times in a row would yield > dramatically different results... 1.001 seconds, 5 seconds, 22 > seconds, 0.01 seconds, to complete. > - When queries are especially slow, the server shows a big spike in > read/write activity. My bet is that you're maxing your disk subsystem somehow. The problem with being I/O bound is that it doesn't matter how great you do on average: if you have too much I/O traffic, it looks like you're stopped. Softraid can be expensive -- first thing I'd look at is to see whether you are in fact hitting 100% of your I/O capacity and, if so, what your options are for getting more room there. A -- Andrew Sullivan | ajs@crankycanuck.ca "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler
В списке pgsql-performance по дате отправления: