Carlos,
Try doing an strace of the postmaster process and see if you can post the lines which hang... Ian On Tue, 9 Apr 2002 [EMAIL PROTECTED] wrote: > Try turning on debugging, it might give you more clues. > > -----Original Message----- > From: CYWare [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 3:46 AM > To: [EMAIL PROTECTED] > Subject: [plug] HELP!!! PostgeSQL Hangs > > Hi, > > Just switched an application from Oracle to PostgreSQL recently. I am > experiencing a strange problem: whenever I execute a relatively heavy query > in PostgreSQL, it just hangs. To isolate the problem, I've tried executing > the query directly from psql instead of using the application itself and > have gotten the same results. I've even tried vacuuming all the tables. > > Anyway, viewing the process list reveals a postmaster process that takes up > 99.9% of the CPU time and just executes forever. Each time I execute a > relatively heavy query, a new postmaster process get stuck. The queries > aren't really complex, i.e. a sum on a 3 table join (about 200,000 rows for > the biggest table). Like I said, Oracle takes at most, 40 seconds to > process the same query with the same data on the same machine (dual PIII > with 1GB RAM). Something must be wrong...please help!!! > > OS: RH6.2 > DB: PG 7.2 > APP: CGI (using pqlib) > KERNEL: 2.4.18 (just in case it makes a diff) > > From, > Carlos Yu > CYWare > > > _ > Philippine Linux Users Group. Web site and archives at > http://plug.linux.org.ph > To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] > > To subscribe to the Linux Newbies' List: send "subscribe" in the body to > [EMAIL PROTECTED] > _ > Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph > To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] > > To subscribe to the Linux Newbies' List: send "subscribe" in the body to >[EMAIL PROTECTED] > _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
