Guthrie, Jeremy jeremy.guthrie
Thu Jul 15 19:07:16 PDT 2004
First off, congrats to the writers of Slony.  Excellent software.

I am putting it through its paces as I try to update my application to better account for Slony.  My application au
tomatically takes care of weekly reindexing because of the volume of data that changes daily.  However it is runnin
g into errors when looking at the Slony Indexes.  Reindex is erroring out on the '-'.  I thought I saw something ab
out this before but I cannot find where.   Specifically, the index is  tsyslog__Slony-I_tsyslog_cluster_rowID_key.

1.
a)  should I worry about having to reindex this?
b)  if so, how?  psql won't let me.

2.  I've noticed that the above listed index seems to stay the same size after running a replication test.  Is my a
ssumption correct that because of how Slony behaves that it will rarely leave unused index space?

3.  By doing a full vacuum or a reindex, will that block an entire replication set or the one table of the set till
 the full vacuum or reindex finishes?
4.  If you want me to be quiet, just say so.  ;)



More information about the Slony1-general mailing list