Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade and epoch - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_upgrade and epoch
Date
Msg-id 20140903025905.GC14893@momjian.us
Whole thread Raw
In response to Re: pg_upgrade and epoch  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: pg_upgrade and epoch
Re: pg_upgrade and epoch
List pgsql-hackers
Tree view 
On Wed, Apr 23, 2014 at 12:41:41PM -0700, Sergey Konoplev wrote:
> On Wed, Apr 23, 2014 at 5:26 AM, Bruce Momjian <bruce@momjian.us> wrote:
> > Sergey, are you seeing a problem only because you are
> > interacting with other systems that didn't reset their epoch?
>
> I faced this after upgrading clusters with PgQ Skytools3 installed
> only. They didn't interact with any other systems.

I have developed the attached patch which causes pg_upgrade to preserve
the transaction epoch.  I plan to apply this for PG 9.5.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +
Attachment

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: B-Tree support function number 3 (strxfrm() optimization)
Next
From: Xiaoyulei
Date:
Subject: Re: why after increase the hash table partitions, TPMC decrease