On 1月20日, 上午6時46分, g...@2ndquadrant.com (Greg Smith) wrote:
> Kevin Grittner wrote:
> > Or just test it in psql. BEGIN, run your query, look at pg_locks.
> > If an xid has been assigned, you'll see it there in the
> > transactionid column. You can easily satisfy yourself which
> > statements grab
On 1月19日, 下午10時39分, kevin.gritt...@wicourts.gov ("Kevin Grittner")
wrote:
> Filip Rembia*kowski wrote:
> > 2011/1/19 Charles.Hou :
> >> " select * from mybook" SQL command also increase the XID ?
>
> > Yes. Single SELECT is a transaction. Hence, it ne
On 1月19日, 下午5時19分, "Charles.Hou" 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?
>
> " se
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/routi
