Chester Kustarz <[EMAIL PROTECTED]> writes: > i have some tables which are insert only. i do not want to vacuum them > because there are never any dead tuples in them and the vacuum grows the > indexes.
Those claims cannot both be true. In any case, plain vacuum cannot grow the indexes --- only a VACUUM FULL that moves a significant number of rows could cause index growth. > vacuum is to reclaim dead tuples. this means it depends on update and > delete. analyze depends on data values/distribution. this means it depends on > insert, update, and delete. thus the dependencies are slightly different > between the 2 operations, an so you can come up with use-cases that > justify running either more frequently. Agreed. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings