On Mon, March 24, 2008 8:35 pm, Andrew Sullivan wrote:
> Yes, busy with SELECT "_xxx_cluster".finishTableAfterCopy(19);
>
> I don't know why that'd take a long time, though, unless there's a lock
> somewhere.  Is there?  What does pg_locks say?

I'm not sure what I'm looking at in pg_locks.  If I exec:

select  p.*,t.relname from pg_locks p, pg_stat_all_tables t where
p.relation=t.relid;

I get lots of info.  Any idea what relation/lock should I look out/refine
for?

Thanks
h