"Charles.Hou" <givemeegn@gmail.com> wrote:
> my postgresql version is 8.1.3
Ouch! That's getting pretty old; I hope it's not on Windows.
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policyhttp://www.postgresql.org/about/news.865
> you means the newer version has a virtual transaction ID. and
> what's the maxmium of this virtual id, also 4 billion ?
> should i also vacuum freeze the virtual id in the new version when
> it reached the 4 billion?
The point is to reduce maintenance, not increase it -- you don't
need to worry about cleaning these up.
-Kevin