[Dspam-user] [pgsql] purge-pe script, order of commands

[Marcin M. <ma...@me...>]

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