pg.ddx.io  pgsql-patches@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Matthew T. O'Connor <matthew@zeut.net>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Pavan Deolasee <pavan.deolasee@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [PATCHES] VACUUM Improvements - WIP Patch
Date: Sun, 24 Aug 2008 14:40:23 -0400
Message-ID: <48B1AB17.9010905@zeut.net> (raw)
In-Reply-To: <48B1831F.7010002@commandprompt.com>
References: <2e78013d0807132050j16cdc558s4dc3f889371a937d@mail.gmail.com>
	<200808230336.m7N3aOc15945@momjian.us>
	<b42b73150808240630r59ad34f3l24a980280cdc52d9@mail.gmail.com>
	<48B1831F.7010002@commandprompt.com>

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.

view thread (17+ messages)  latest in thread

Message-ID: <48B1AB17.9010905@zeut.net>
Permalink:  ../48B1AB17.9010905@zeut.net/
Also on:    postgresql.org/message-id/48B1AB17.9010905@zeut.net

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-patches@postgresql.org
  Cc: matthew@zeut.net, jd@commandprompt.com, mmoncure@gmail.com, bruce@momjian.us, pavan.deolasee@gmail.com, tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org
  Subject: Re: [PATCHES] VACUUM Improvements - WIP Patch
  In-Reply-To: <48B1AB17.9010905@zeut.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox