Thu Jul 15 19:07:16 PDT 2004
- Previous message: [Slony1-general] Dealing with postgres restart
- Next message: [Slony1-general] Slony index space usage
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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. ;)
- Previous message: [Slony1-general] Dealing with postgres restart
- Next message: [Slony1-general] Slony index space usage
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list