Tom Lane wrote:
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

Reply via email to