Tom Lane wrote:
> Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp> writes:
>> If we can stop at any point, we can make maintenance memory large
>> sufficient to contain all of the dead tuples, then we only need to
>> clean index for once. No matter how many times vacuum stops,
>> indexes are cleaned for once.
> I beg your pardon? You're the one who's been harping on the
> table-so-large-it-takes-days-to-vacuum scenario. How you figure that
> you can store all the dead TIDs in working memory?
This reminds me of an idea I had while looking at the bitmap index
patch: We could store the dead TIDs more efficiently in a bitmap,
allowing tables to be vacuumed in lesser cycles.
Of course, that's orthogonal to the above discussion.
In response to
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2007-02-28 09:51:46|
|Subject: Re: Dead Space Map version 2|
|Previous:||From: Tom Lane||Date: 2007-02-28 08:49:55|
|Subject: Re: Resumable vacuum proposal and design overview |