process hangs using perl?

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: process hangs using perl?
Date: 2003-10-09 23:36:13
Message-ID: OFF6DF5676.D9C2DFBF-ON88256DBA.00807320-88256DBA.00825250@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-10-09 23:41:35 Re: RE : Is the use of array as PL/PGSQL function arguments
Previous Message tj 2003-10-09 23:32:20 Re: simple remote user access question - pg_hda.conf