Re: Insert only tables and vacuum performance
Joseph Shraibman <jks@selectacast.net>
From: Joseph Shraibman <jks@selectacast.net>
To: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-performance@postgresql.org
Date: 2004-04-30T05:57:44Z
Lists: pgsql-performance
Tom Lane wrote: > Joseph Shraibman <jks@selectacast.net> 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?