Simon Riggs <[email protected]> writes:
> On Fri, Jul 15, 2011 at 5:10 PM, David Ondrejik <[email protected]>
> wrote:
>> Since then, the process has continued to run (for about 20 hrs) without any
>> additional information being returned.
> Probably locked behind another long running task that is holding a buffer pin.
That's possible, or it could be busy vacuuming some (really large?)
index. Is the process actually busy, as in consuming CPU time according
to top or other process monitoring tool?
regards, tom lane
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin