Re: Vacuum improvement - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Vacuum improvement
Date
Msg-id 20811.1034740355@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum improvement  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: Vacuum improvement  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Gavin Sherry <swm@linuxworld.com.au> writes:
> have a parameter which specified how much of the table is vacuumed. That
> is, you could specify:
> VACUUM FULL test 20 precent;

Erm ... but which 20 percent?  In other words, how could you arrange for
repeated applications of such a command to cover the whole table, and
not just retrace an already-cleaned-out portion?

I don't object to the idea in principle, but I am not sure how to
implement it in practice.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.)
Next
From: Alvaro Herrera
Date:
Subject: Re: Vacuum improvement