Re: Queries sometimes take 1000 times the normal time

Поиск
Список
Период
Сортировка
Искать
От
Rod Taylor
Тема
Re: Queries sometimes take 1000 times the normal time
Дата
Msg-id
1062095603.79027.205.camel@jester
Ответ на
Список
Дерево обсуждения
Re: Queries sometimes take 1000 times the normal time "Anders K. Pedersen" <akp@cohaesio.com>
> With regards to other jobs on the server, there is a MySQL server on it 
> as well, which from time to time has some multi-second queries generated 
> from a webserver also on this host, but the MySQL is running with nice 
> 10 (PostgreSQL isn't nice'd).

Do those MySQL queries hit disk hard?

I've never seen PostgreSQL have hicups like you describe when running on
a machine by itself.  I have experienced similar issues when another
process (cron job in my case) caused brief swapping to occur.
В списке pgsql-performance по дате отправления
От: Rod Taylor
Дата:
От: Stephan Szabo
Дата:
FAQ