Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



mljv@xxxxxxxxxxxx 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux