On Fri, Jan 14, 2005 at 11:18:15AM -0700, Michael Fuhr wrote: > > Since you say the query takes forever to return, it might be useful > to see the output of pg_locks.
Reminder to self: "takes forever to return" might mean "eventually returns, but takes a long time". Should have asked for clarification and EXPLAIN or EXPLAIN ANALYZE output. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
