"Charles.Hou" <givemeegn@xxxxxxxxx> 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_Policy http://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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance