"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
The following bug has been logged online:
Bug reference: 2027
Logged by: Dmitri Fuerle
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Mac OS X
Description:Select on view hangs.
Details:
A select on the following view hangs the database
an
