Andrew Sullivan ajs at crankycanuck.ca
Mon Mar 24 11:35:05 PDT 2008
On Mon, Mar 24, 2008 at 08:21:20PM +0200, Henry wrote:
> current_query | select "_xxx_cluster".finishTableAfterCopy(19); analyze
> "public"."indexing_page";
> age           | 07:10:51.116112
> 
> Am I miss-reading the info above?  Is it busy with an analyze, or is it
> busy chugging away on something else prior to the analyze (the delimiter ;
> seems to imply that)?

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?

A



More information about the Slony1-general mailing list