Running a perl script against my dev server (pg 7.3.4) that currently runs fine on the production server. And for some reason Pg always seems to hang during the process (see below for Top print out). This happens randomily throughout the script and can be on a SELECT, INSERT, or UPDATE statement, but doesn't cause the Pg server to go down (which is good). Any suggestions on where to start looking?
Perl version 5.6.1 ---Top print out 4:08pm up 23 days, 4:46, 3 users, load average: 1.00, 1.05, 1.39 78 processes: 75 sleeping, 2 running, 1 zombie, 0 stopped CPU0 states: 30.4% user, 4.0% system, 0.0% nice, 64.4% idle CPU1 states: 47.0% user, 3.3% system, 0.0% nice, 49.0% idle Mem: 513640K av, 505332K used, 8308K free, 0K shrd, 13176K buff Swap: 2044056K av, 48624K used, 1995432K free 356028K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 16094 postgres 14 0 98.8M 97M 18900 R 85.2 19.4 31:38 postgres: phatcher mdc_oz [local] SELECT 16655 postgres 9 0 1052 1052 836 R 0.1 0.2 0:00 top 14397 postgres 8 0 1964 1840 1708 S 0.0 0.3 0:00 /usr/local/postgresql7.3.4/bin/postmaster 14398 postgres 9 0 2932 2780 1700 S 0.0 0.5 0:03 postgres: stats buffer process 14399 postgres 9 0 2168 2016 1704 S 0.0 0.3 0:05 postgres: stats collector process 16074 postgres 9 0 23836 20M 18884 S 0.0 4.1 16:24 postgres: phatcher mdc_oz [local] SELECT waiting 16076 postgres 9 0 21792 20M 18916 S 0.0 4.1 644:42 postgres: phatcher mdc_oz [local] SELECT waiting 16546 postgres 9 0 17988 16M 17208 S 0.0 3.3 0:11 postgres: phatcher mdc_oz [local] SELECT waiting 16650 postgres 9 0 1332 1332 1060 S 0.0 0.2 0:00 /bin/bash TIA Patrick Hatcher ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
