Re: Extrordinarily Poor Performance.... - Mailing list pgsql-hackers
From | Bruce Momjian |
---|---|
Subject | Re: Extrordinarily Poor Performance.... |
Date | |
Msg-id | 200105040145.f441jKF13128@candle.pha.pa.us Whole thread Raw |
In response to | Re: Extrordinarily Poor Performance.... (Ryan Mahoney <ryan@paymentalliance.net>) |
List | pgsql-hackers |
I hope you have those postmasters listening on different ports. > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
pgsql-hackers by date: