Re: Very long execution time of "select nextval('..');"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Very long execution time of "select nextval('..');"
Дата
Msg-id 14081.1201470278@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Very long execution time of "select nextval('..');"  (mljv@planwerk6.de)
Ответы Re: Very long execution time of "select nextval('..');"  (mljv@planwerk6.de)
Список pgsql-general
mljv@planwerk6.de writes:
> ok, at the moment i got some traffic and my load is at 1.5. But now with
> logging the timestamp I have seen that the long durations are quite regular
> at intervals of 10 minutes.

Well, that's pretty suggestive.  Tell us about your checkpoint and
bgwriter settings.  Also, is there any other service running on the
machine that might have activity spikes every 10 minutes?

            regards, tom lane

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

Предыдущее
От: mljv@planwerk6.de
Дата:
Сообщение: Re: Very long execution time of "select nextval('..');"
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Very long execution time of "select nextval('..');"