Tom Lane wrote:
> Joseph Shraibman <jks(at)selectacast(dot)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
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
In response to
pgsql-performance by date
|Next:||From: Gary Doades||Date: 2004-04-30 06:33:11|
|Subject: Re: planner/optimizer question |
|Previous:||From: Achilleus Mantzios||Date: 2004-04-30 05:49:41|
|Subject: Re: Use arrays or not?|