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)
Список
Дерево обсуждения
Very long execution time of "select nextval('..');" mljv@planwerk6.de
Re: Very long execution time of "select nextval('..');" Tom Lane <tgl@sss.pgh.pa.us>
Re: Very long execution time of "select nextval('..');" mljv@planwerk6.de
Re: Very long execution time of "select nextval('..');" Tom Lane <tgl@sss.pgh.pa.us>
Re: Very long execution time of "select nextval('..');" mljv@planwerk6.de
Re: Very long execution time of "select nextval('..');" Greg Smith <gsmith@gregsmith.com>
Re: Very long execution time of "select nextval('..');" mljv@planwerk6.de
Re: Very long execution time of "select nextval('..');" Shane Ambler <pgsql@Sheeky.Biz>
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
Дата:
