On 1月19日, 下午5時19分, "Charles.Hou" <giveme...@gmail.com> wrote: > after i backdb->dropdb->restoredb and then vacuum analy+full -> vacuum > freeze > > the XID had been increased by 4 billion in two weeks...is it noraml? > > what's the definetion of XID? > > " select * from mybook" SQL command also increase the XID ? > > reference:http://www.postgresql.org/docs/9.0/static/routine-vacuuming.html
sorry... not 4 billion , is 4 hundred million -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance