On Tue, Apr 09, 2002 at 03:46:08AM +0800, CYWare wrote:
> 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. What does EXPLAIN say about the query? eric -- ___ eric pareja ([EMAIL PROTECTED]) User #8159 http://counter.li.org \e/ [ Chiba City: A Cyberpunk MUSH - http://chibacity.erisian.net ] GNU/Linux v [ Philippine Linux Users' Group + http://plug.linux.org.ph ] Software & [ IRC /join #plug @irc.free.net.ph every evening 10pm onwards ] Freedom "...the symbol is nothing. It is the reality behind every symbol that is all." _ 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]
