On 1月19日, 下午5時19分, "Charles.Hou" <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
