Re: Extrordinarily Poor Performance.... - Mailing list pgsql-hackers
| From | Ryan Mahoney |
|---|---|
| Subject | Re: Extrordinarily Poor Performance.... |
| Date | |
| Msg-id | 5.0.2.1.0.20010503212724.026aa060@paymentalliance.net Whole thread Raw |
| In response to | Extrordinarily Poor Performance.... (Ryan Mahoney <ryan@paymentalliance.net>) |
| Responses |
Re: Extrordinarily Poor Performance....
(Bruce Momjian <pgman@candle.pha.pa.us>)
|
| List | pgsql-hackers |
Here is some output from top...
9:20pm up 40 min, 1 user, load average: 3.77, 3.12, 3.74
41 processes: 36 sleeping, 5 running, 0 zombie, 0 stopped
CPU states: 99.2% user, 0.7% system, 0.0% nice, 0.0% idle
Mem: 515664K av, 303712K used, 211952K free, 37476K shrd, 39552K buff
Swap: 514068K av, 0K used, 514068K free 158980K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
1657 postgres 20 0 6820 6820 5712 R 33.4 1.3 0:12 postmaster
1671 postgres 20 0 6576 6576 5468 R 33.4 1.2 0:08 postmaster
1650 postgres 19 0 6952 6952 5848 R 32.6 1.3 0:16 postmaster
1444 postgres 0 0 1044 1044 844 R 0.5 0.2 0:02 top
1 root 0 0 540 540 476 S 0.0 0.1 0:06 init
2 root 0 0 0 0 0 SW 0.0 0.0 0:02 kflushd
3 root 0 0 0 0 0 SW 0.0 0.0 0:04 kupdate
4 root 0 0 0 0 0 SW 0.0 0.0 0:00 kpiod
5 root 0 0 0 0 0 SW 0.0 0.0 0:00 kswapd
6 root -20 -20 0 0 0 SW< 0.0 0.0 0:00 mdrecoveryd
373 root 0 0 836 836 700 S 0.0 0.1 0:00 syslogd
383 root 0 0 852 852 472 S 0.0 0.1 0:00 klogd
398 rpc 0 0 580 580 492 S 0.0 0.1 0:00 portmap
414 root 0 0 0 0 0 SW 0.0 0.0 0:00 lockd
415 root 0 0 0 0 0 SW 0.0 0.0 0:00 rpciod
425 rpcuser 0 0 832 832 720 S 0.0 0.1 0:00 rpc.statd
477 nobody 0 0 720 720 612 S 0.0 0.1 0:00 identd
484 nobody 0 0 720 720 612 S 0.0 0.1 0:00 identd
485 nobody 0 0 720 720 612 S 0.0 0.1 0:00 identd
488 nobody 0 0 720 720 612 S 0.0 0.1 0:00 identd
489 nobody 0 0 720 720 612 S 0.0 0.1 0:00 identd
496 daemon 0 0 580 580 504 S 0.0 0.1 0:00 atd
511 root 0 0 1040 1040 828 S 0.0 0.2 0:00 xinetd
520 root 0 0 1196 1196 1060 S 0.0 0.2 0:00 sshd
533 root 0 0 2008 2008 1652 R 0.0 0.3 0:00 sshd
542 lp 0 0 1112 1112 948 S 0.0 0.2 0:00 lpd
579 root 0 0 512 512 448 S 0.0 0.0 0:00 gpm
594 root 0 0 720 720 616 S 0.0 0.1 0:00 crond
679 xfs 0 0 4496 4496 808 S 0.0 0.8 0:00 xfs
704 ryan 0 0 1328 1328 1036 S 0.0 0.2 0:00 bash
752 postgres 0 0 2492 2492 2360 S 0.0 0.4 0:01 postmaster
778 root 0 0 444 444 380 S 0.0 0.0 0:00 mingetty
779 root 0 0 444 444 380 S 0.0 0.0 0:00 mingetty
780 root 0 0 444 444 380 S 0.0 0.0 0:00 mingetty
781 root 0 0 444 444 380 S 0.0 0.0 0:00 mingetty
782 root 0 0 444 444 380 S 0.0 0.0 0:00 mingetty
783 root 0 0 444 444 380 S 0.0 0.0 0:00 mingetty
1279 root 0 0 1060 1060 856 S 0.0 0.2 0:00 su
1280 root 0 0 1388 1388 1076 S 0.0 0.2 0:00 bash
1369 root 0 0 1020 1020 828 S 0.0 0.1 0:00 su
1370 postgres 0 0 1308 1308 1028 S 0.0 0.2 0:00 bash
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
pgsql-hackers by date: