On 2 Aug 2010, at 20:37, Kenneth Marshall wrote:
> Although adding local free space to the tables is needed as well for HOT
> updates to work so you probably need to run a CLUSTER after the database
> reaches a production steady state. I have not yet tested, but I would think
> that a yearly maintenance period would suffice.
Oh, good call! I totally forgot I did this (years ago):
Indexes:
"dspam_token_data_uid_key" UNIQUE, btree (uid, token) CLUSTER
Doing that on a large installation already in existence would be rather painful
though (it reorders the entire table on disk!). It's probably best to do that
after the initial training and then have it updated by a daily job (could be
the purge job, after vacuuming), that should have significantly less impact.
Don't take my word for it, my installation is rather small (home server) - if
someone with a "big" installation (a matter of perspective of course) and
opportunity to experiment could confirm this makes a difference, great!
Alban Hertroys
--
Screwing up is an excellent way to attach something to the ceiling.
!DSPAM:1126,4c571d9d286213294915985!
------------------------------------------------------------------------------
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
