| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] VACUUM Improvements - WIP Patch |
| Date: | 2008-08-24 18:40:23 |
| Message-ID: | 48B1AB17.9010905@zeut.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Joshua D. Drake wrote:
> Merlin Moncure wrote:
>> Well, there doesn't seem to be a TODO for partial/restartable vacuums,
>> which were mentioned upthread. This is a really desirable feature for
>> big databases and removes one of the reasons to partition large
>> tables.
> I would agree that partial vacuums would be very useful.
I think everyone agrees that partial vacuums would be useful / *A Good
Thing* but it's the implementation that is the issue. I was thinking
about Alvaro's recent work to make vacuum deal with TOAST tables
separately, which is almost like a partial vacuum since it effectively
splits the vacuum work up into multiple independent blocks of work, the
limitation obviously being that it can only split the work around
TOAST. Is there anyway that vacuum could work per relfile since we
already split tables into files that are never greater than 1G? I would
think that if Vacuum never had more than 1G of work to do at any given
moment it would make it much more manageable.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2008-08-24 18:51:27 | Re: Extending error-location reports deeper into the system |
| Previous Message | D'Arcy J.M. Cain | 2008-08-24 18:33:34 | Re: Proposal: new border setting in psql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-08-24 19:16:08 | Re: [PATCHES] VACUUM Improvements - WIP Patch |
| Previous Message | Joshua D. Drake | 2008-08-24 15:49:51 | Re: [PATCHES] VACUUM Improvements - WIP Patch |