Re: Resumable vacuum proposal and design overview - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Resumable vacuum proposal and design overview
Date
Msg-id 21490.1172639457@sss.pgh.pa.us
Whole thread Raw
In response to Re: Resumable vacuum proposal and design overview  (Galy Lee <lee.galy@oss.ntt.co.jp>)
Responses Re: Resumable vacuum proposal and design overview  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
Galy Lee <lee.galy@oss.ntt.co.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?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Proposal for Implenting read-only queries during wal replay (SoC 2007)
Next
From: "Henry B. Hotz"
Date:
Subject: Re: 5 Weeks till feature freeze or (do you know where your patch is?)