Search Postgresql Archives

Re: Spurious Stalls

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

 



The cpu utilization increases to nearly 100%, in user space, and stays there, until the database is restarted.

postgres  1323 47.1  2.3 6667212 6087388 ?     Rs   00:00 276:00  \_ postgres: bitbucket bitbucket 172.17.10.1(5114) SELECT          

I see you have long-query logging enabled, what was this query doing? It seems like the oddball from your ps output, it was taking half your CPU. Or did you have to kill the db before it logged anything out. If so, while debugging something with a memory problem here we set up a cronjob to log out all running queries every minute, before the oom-killer would start killing stuff, maybe you could catch the culprit next time.

For the pids that you included strace outputs for, curious, why did you pick them? Were they using a lot of CPU? Except for the postmaster one (81372), I didn't see them in the ps output.



[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