the XID question

From: "Charles(dot)Hou" <givemeegn(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: the XID question
Date: 2011-01-19 09:19:15
Message-ID: ca4f167a-0c04-4c59-9dec-a10d8f43437b@i25g2000prd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Charles.Hou 2011-01-19 10:21:55 Re: the XID question
Previous Message Achilleas Mantzios 2011-01-19 09:10:05 Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2