"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
>>> Alvaro Herrera <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
