[PERFORM] Idle postmaster taking up a lot of CPU

2004-01-17 Thread John Siracusa
Here's the top item from the "top" listing on my Postgres machine: 10:20am up 98 days, 18:28, 3 users, load average: 1.14, 1.09, 0.85 103 processes: 101 sleeping, 1 running, 0 zombie, 1 stopped CPU0 states: 38.0% user, 13.1% system, 0.0% nice, 48.3% idle CPU1 states: 39.0% user, 11.3% system,

Re: [PERFORM] Idle postmaster taking up a lot of CPU

2004-01-17 Thread Tom Lane
John Siracusa <[EMAIL PROTECTED]> writes: > Process 20753 was hovering around 60-70% CPU usage for a long time. > I tried to see what that postmaster was doing, but it appeared to be "idle" > % ps -wwwx -p 20753 > PID TTY STAT TIME COMMAND > 20753 pts/3R 26:59 postgres: postgres

Re: [PERFORM] Postgres on Netapp

2004-01-17 Thread D'Arcy J.M. Cain
On January 16, 2004 11:53 am, Larry Rosenman wrote: > --On Monday, January 12, 2004 13:45:45 -0800 Shankar K <[EMAIL PROTECTED]> > wrote: > > We are considering to use NetApp filer for a highly > > busy 24*7 postgres database and the reason we chose > I run a (not very busy) PG cluster on a NetAPP.

Re: [PERFORM] Idle postmaster taking up a lot of CPU

2004-01-17 Thread John Siracusa
On 1/17/04 12:32 PM, Tom Lane wrote: > John Siracusa <[EMAIL PROTECTED]> writes: >> Process 20753 was hovering around 60-70% CPU usage for a long time. > >> I tried to see what that postmaster was doing, but it appeared to be "idle" > >> % ps -wwwx -p 20753 >> PID TTY STAT TIME COMMAND >