On Mon, 25 Nov 2002, Tom Lane wrote:
> "scott.marlowe" <scott.marlowe@ihs.com> writes:
> > Also, full vacuums are required every so often to keep the transaction id
> > from rolling over.
>
> Not so; a plain vacuum is fine for that. The critical point is that
> *every* table in *every* database has to be vacuumed (plain or full)
> at least once every billion transactions or so.
Really? Sorry for the misiniformation. I could have sworn that I read it
on this or the hackers mailing list that only full vacuums could reset the
transaction counter.
Thanks for the catch.