Mike Bridge <[EMAIL PROTECTED]> writes: > I've been running Postgresql 7.4.1 for a couple weeks after upgrading > from 7.2. I noticed today that the postmaster had been using 99% of > the dual CPUs (on a PowerEdge 2650) non-stop for the last couple days. > I stopped all the clients, and it didn't abate---even with no > connections---so I restarted the postmaster. Now everything is > running smoothly again.
Since the postmaster is a single unthreaded process, it's quite impossible for it to take up 100% of two CPUs. Could you be more precise about which processes were eating CPU, and what they were doing according to the available state data? (ps auxww and pg_stat_activity can be helpful tools.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org