Re: Extrordinarily Poor Performance....

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026