>Try doing an strace of the postmaster process and see if you can post the >lines which hang...
don't really know how to do that. >What does EXPLAIN say about the query? nothing unusual. a few nested loops, a few indexes being used and one table scan towards the end which means the rows have been minimized >Try turning on debugging, it might give you more clues. recompiled with the --enable-debug flag and altered postgresql.conf to allow debugging messages but couldn't really get any useful information on the logs. FYI: I accidentally fixed the problem!!! its a bit strange. i dropped two indexes on one table and the query executed in less than 8 seconds. seems like the parser was getting confused with too many indexes and would just hang. _ 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]
