SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 09:04 AM
| ||||
| ||||
 BUG #1806: Postmaster takes uses 99% of CPU The following bug has been logged online: Bug reference: 1806 Logged by: Email address: m.krueger@chs.de PostgreSQL version: 7.4.8-0.6 Operating system: Suse Linux Enterprise Server 9 Description: Postmaster takes uses 99% of CPU Details: The Prozess Postmaster takes 99% of Cpu. PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 20726 postgres 17 0 19996 5356 4216 R 98.3 0.3 26:36.56 postmaster 19956 postgres 19 0 19996 6148 4936 R 64.4 0.3 28:38.38 postmaster 20005 postgres 24 0 19996 6244 5068 R 23.6 0.3 36:25.35 postmaster 19955 postgres 22 0 20060 6364 5156 R 10.3 0.3 34:25.64 postmaster 20014 postgres 17 0 19992 5264 4136 R 5.6 0.3 15:17.95 postmaster 10454 tomcat 25 0 608m 426m 12m S 0.3 21.1 12:47.47 java I have read all the Faq. But there is no reason to it. Could you help? ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
|
04-10-2008, 09:04 AM
| ||||
| ||||
| Re: BUG #1806: Postmaster takes uses 99% of CPU m.krueger@chs.de wrote: > The Prozess Postmaster takes 99% of Cpu. > > PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND > 20726 postgres 17 0 19996 5356 4216 R 98.3 0.3 26:36.56 postmaster > 19956 postgres 19 0 19996 6148 4936 R 64.4 0.3 28:38.38 postmaster .... > I have read all the Faq. But there is no reason to it. > Could you help? Is it doing anything? Do your logs show any activity? If you do "strace -p <pid>" as root, you'll see what system calls the backend is making. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
Linear Mode
