Skip site navigation (1) Skip section navigation (2)

Re: Insert only tables and vacuum performance

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Insert only tables and vacuum performance
Date: 2004-04-30 05:57:44
Message-ID: 4091EAD8.4020503@selectacast.net (view raw or flat)
Thread:
Lists: pgsql-performance
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 
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?

In response to

Responses

pgsql-performance by date

Next:From: Gary DoadesDate: 2004-04-30 06:33:11
Subject: Re: planner/optimizer question
Previous:From: Achilleus MantziosDate: 2004-04-30 05:49:41
Subject: Re: Use arrays or not?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group