Re: Queries sometimes take 1000 times the normal time

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Queries sometimes take 1000 times the normal time
Дата
Msg-id 1062033258.71328.2.camel@jester
обсуждение исходный текст
Ответ на Queries sometimes take 1000 times the normal time  ("Anders K. Pedersen" <akp@cohaesio.com>)
Список pgsql-performance
> Currently there's only a few users in the database for testing purposes,
> and most of the time the user lookup's take 2-3 ms (I have syslog'ing of
> queries and duration turned on), but several times per hour the duration
> for one of the queries is 2-3 seconds (1000 times larger), while the
> surrounding lookups take the usual 2-3 ms.

Are there any other jobs running at the time of these excessive queries?

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: matt
Дата:
Сообщение: Re: Hardware recommendations to scale to silly load
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Simple queries take forever to run