FreeBSD 6.2 Postgresql 8.1.4 Slony 1.2.6 I had a table tablename that had been part of a replication set. I had to change up things such that this table would be replicated to 2 subscribers so I: 1) SET DROP TABLE to remove said table from the current set 2) CREATE SET to create a new set to hold the table 3) SET ADD TABLE to add tablename to the SET 4) subscribe set (id = 48, provider = 1, receiver = 2, forward = no); subscribe set (id = 48, provider = 1, receiver = 3, forward = no);
Now I realize that receiver node 3 won't receive any data until 2 is subscribed (and is confirmed by the "data provider 1 only on sync" messages on node 3). I was monitoring node 2 and saw the 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? Sven _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
