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 BEGIN; CREATE unique index dspam_signature_data_uid_key_TEMP on .... ; -- sadly, create index concurrently can't be used inside transaction DROP index dspam_signature_data_uid_key ALTER index dspam_signature_data_uid_key_TEMP rename to dspam_signature_data_uid_key; COMMIT; VACUUM ANALYSE dspam_signature_data; What do you think about it? Regards, Marcin Mirosław ------------------------------------------------------------------------------ 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
