"Dmitri Fuerle" <[EMAIL PROTECTED]> writes:
> A select on the following view hangs the database
Are you sure it's actually hung, and not (say) computing like mad?
Perhaps the planner chose a bad plan that will take a long time.
Have you ANALYZEd all the tables underlying the view?
Dmitri Fuerle wrote:
> A select on the following view hangs the database
> and produces the lock table at the bottom of the message
It doesn't look like it's actually waiting on a lock (unless you managed
to paste only a portion of pg_locks). Are you running on NFS or some
such?
--
Alvaro Her
