pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Charles.Hou <givemeegn@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: the XID question
Date: Thu, 20 Jan 2011 11:04:59 -0600
Message-ID: <4D3816DB02000025000398DF@gw.wicourts.gov> (raw)
In-Reply-To: <b5fc661d-0c4b-4dd9-ab56-06888410188c@m20g2000prc.googlegroups.com>
References: <ca4f167a-0c04-4c59-9dec-a10d8f43437b@i25g2000prd.googlegroups.com>
	<AANLkTim8MsWWPw3hL_U_U2cdv3us24MgP7TwcFJp2hVy@mail.gmail.com>
	<4D36A35302000025000397CC@gw.wicourts.gov>
	<b5fc661d-0c4b-4dd9-ab56-06888410188c@m20g2000prc.googlegroups.com>

"Charles.Hou" <givemeegn@gmail.com> wrote:
 
> my postgresql version is 8.1.3
 
Ouch!  That's getting pretty old; I hope it's not on Windows.
 
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy
 
http://www.postgresql.org/about/news.865
 
> you means the newer version has a virtual transaction ID. and
> what's the maxmium of this virtual id,  also 4 billion ?
> should i also vacuum freeze the virtual id in the new version when
> it reached the 4 billion?
 
The point is to reduce maintenance, not increase it -- you don't
need to worry about cleaning these up.
 
-Kevin



view thread (12+ messages)  latest in thread

Message-ID: <4D3816DB02000025000398DF@gw.wicourts.gov>
Permalink:  ../4D3816DB02000025000398DF@gw.wicourts.gov/
Also on:    postgresql.org/message-id/4D3816DB02000025000398DF@gw.wicourts.gov

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, givemeegn@gmail.com
  Subject: Re: the XID question
  In-Reply-To: <4D3816DB02000025000398DF@gw.wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox