Tom, Thanks But are there just 28 (the 28 that have been vacuumed), or are there more (in 7.4). Happy there's no guarantee, but would help to know any possible damager in my current situation, Thanks S -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: 24 October 2006 15:23 To: Shane Wright Cc: Martijn van Oosterhout; pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] recovery from xid wraparound "Shane Wright" <shane.wright@xxxxxxxxxxxxxxxxxxxx> writes: >> Just make sure you've really covered *all* the system tables. > I've been under the impression system tables get done first, then > user(me)-created tables after - No, there's no such guarantee. A database-wide vacuum just does the tables in the order it finds 'em in pg_class. regards, tom lane
