Tom Lane [tgl@xxxxxxxxxxxxx] wrote:
Are those processes actually doing anything, or just waiting? strace
or local equivalent would be the most conclusive check.
These must not have been hung, because they finally completed (after
10-15 hrs - some time between 11pm and 8am). Question is why does it
take so long to do this on such a relatively small table?
This query isn't very helpful because it fails to show locks that are
not directly associated with tables.
How can that (locks not directly associated...) be determined?
Thanks,
Brian
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
