Joseph Shraibman <[EMAIL PROTECTED]> writes:
I have a table that is never updated, only INSERTED into. Is there a way I can prevent vacuum wasting time on this table
What makes you think vacuum is wasting much time on this table? AFAICS it will only update any unfixed hint bits ...
regards, tom lane
INFO: "elog": found 0 removable, 12869411 nonremovable row versions in 196195 pages
DETAIL: 0 dead row versions cannot be removed yet.
There were 5 unused item pointers.
0 pages are entirely empty.
CPU 31.61s/4.53u sec elapsed 1096.83 sec.
It took 1096.83 seconds, and what did it accomplish? And what are hint bits?
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings