Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] pg_upgrade problem

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] pg_upgrade problem
Date: 2011-08-31 17:45:51
Message-ID: 20110831174550.GA31255@depesz.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Wed, Aug 31, 2011 at 01:23:05PM -0400, Bruce Momjian wrote:
> Can you get me the 9.0.X pg_class.relfrozenxid for the toast and heap
> tables involved?

Sure:

=# select oid::regclass, relfrozenxid from pg_class  where relname in ('transactions', 'pg_toast_106668498');
             oid             | relfrozenxid 
-----------------------------+--------------
 pg_toast.pg_toast_106668498 |   3673553926
 transactions                |   3623560321
(2 rows)

Best regards,

depesz

-- 
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-08-31 18:09:07
Subject: Re: limit in subquery causes poor selectivity estimation
Previous:From: Bruce MomjianDate: 2011-08-31 17:35:25
Subject: Re: [GENERAL] pg_upgrade problem

pgsql-general by date

Next:From: Tom LaneDate: 2011-08-31 17:47:11
Subject: Re: regression between 8.4.8 and 8.4.2?
Previous:From: Bruce MomjianDate: 2011-08-31 17:35:25
Subject: Re: [GENERAL] pg_upgrade problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group