On 29 Jul 2010, at 23:17, Marcin Mirosław wrote: > Hi everebody! > I'm starting play with DSPAM and still learn how to use it in best way. > I'm loooking into purge-pe.sql script, there is: > VACUUM ANALYSE dspam_token_data; > VACUUM ANALYSE dspam_signature_data; > > REINDEX TABLE dspam_token_data; > REINDEX TABLE dspam_signature_data; > > Meseems vacuum should be done after reindex table, to get statistics > from newly created index. Second thing is reindexing, isn't problematic > that reindex locks table? Imho vacuum and reindex can be done in this > way (which theoretically should be faster ): > - drop constraints [1] > - create unique indexes
I don't think the reindex is necessary at all. That's a corner-case operation that you shouldn't need in normal database operation. I don't see why dspam would need it, at best there'd be some high-volume scenarios where this turns out to be a gain, but for those cases you need custom solutions anyway. Alban Hertroys -- Screwing up is an excellent way to attach something to the ceiling. !DSPAM:1126,4c5219b0286211624032597! ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
