"Jim C. Nasby" <jnasby@pervasive.com> writes:
>>> Alvaro Herrera <alvherre@commandprompt.com> writes:
>>>> So for you it would certainly help a lot to be able to vacuum the first
>>>> X pages of the big table, stop, release locks, create new transaction,
>>>> continue with the next X pages, lather, rinse, repeat.
>>> Bruce and I were discussing this the other day; it'd be pretty easy to
>>> make plain VACUUM start a fresh transaction immediately after it
>>> finishes a scan heap/clean indexes/clean heap cycle.
> Except that wouldn't help when vacuuming a lot of small tables; each one
> would get it's own transaction.
What's your point? There's only a problem for big tables, and VACUUM
already does use a new transaction for each table.
regards, tom lane