Re: the XID question

From: "Charles(dot)Hou" <givemeegn(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: the XID question
Date: 2011-01-19 10:21:55
Message-ID: 89ee4fc4-56bd-436e-921d-5b49b8d0a084@o9g2000pre.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 1月19日, 下午5時19分, "Charles.Hou" <giveme(dot)(dot)(dot)(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Filip Rembiałkowski 2011-01-19 12:00:43 Re: the XID question
Previous Message Charles.Hou 2011-01-19 09:19:15 the XID question