On Thu, 2007-02-08 at 17:37 -0500, Andrew Sullivan wrote: > On Thu, Feb 08, 2007 at 05:15:36PM -0500, Sven Willenberger wrote: > > prepareTableForCopy() function fire and the COPY command go. The table > > of 3 million rows finished copy from stdin fairly quickly but now the > > finishTableAfterCopy(115); analyze tablename has been "running" for some > > 40 minutes now; the only indexes on the thing are the primary key > > (two-column primary) and a single-column index (which "by hand" can be > > recreated in seconds). The cpu that this process has landed on is > > running at near 100% but a ktrace dumps nothing. Ideas? > > Are there any ungranted locks? I assume it's trying to add indexes > back, and it might have a conflict? > > A > Not sure what you mean by ungranted locks. The schemas were created by a regular user (i.e non-superuser) while slony is a superuser and should be able to restore the indexes. What should I look for to match your question?
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
