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]
