Postgres Pro
Downloads
Home   >   mailing lists

Re: Very long execution time of "select nextval('..');" - Mailing list pgsql-general

From Tom Lane
Subject Re: Very long execution time of "select nextval('..');"
Date
Msg-id 14081.1201470278@sss.pgh.pa.us
Whole thread Raw
In response to Re: Very long execution time of "select nextval('..');"  (mljv@planwerk6.de)
Responses Re: Very long execution time of "select nextval('..');"  (mljv@planwerk6.de)
List pgsql-general
Tree view 
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 by date:

Previous
From: mljv@planwerk6.de
Date:
Subject: Re: Very long execution time of "select nextval('..');"
Next
From: Greg Smith
Date:
Subject: Re: Very long execution time of "select nextval('..');"