[PERFORM] High CPU with 7.4.1 after running for about 2 weeks

2004-03-13 Thread Mike Bridge
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 restarte

Re: [PERFORM] High CPU with 7.4.1 after running for about 2 weeks

2004-03-15 Thread Mike Bridge
>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.