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