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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mljv(at)planwerk6(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very long execution time of "select nextval('..');"
Date: 2008-01-27 21:44:38
Message-ID: 14081.1201470278@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mljv(at)planwerk6(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-01-28 00:07:11 Re: Very long execution time of "select nextval('..');"
Previous Message mljv 2008-01-27 21:39:11 Re: Very long execution time of "select nextval('..');"