Warning about oid/xid wraparound

Started by Bruce Momjianover 24 years ago4 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

This patch warns about oid/xid wraparound during VACUUM. Apply the part
people consider appropriate. I may not be around before beta.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Attachments:

/pgpatches/maxoidxidtext/plainDownload+27-1
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#1)
Re: Warning about oid/xid wraparound

Bruce Momjian <pgman@candle.pha.pa.us> writes:

This patch warns about oid/xid wraparound during VACUUM. Apply the part
people consider appropriate. I may not be around before beta.

None of it is appropriate anymore...

regards, tom lane

#3Bruce Momjian
bruce@momjian.us
In reply to: Tom Lane (#2)
Re: Warning about oid/xid wraparound

Bruce Momjian <pgman@candle.pha.pa.us> writes:

This patch warns about oid/xid wraparound during VACUUM. Apply the part
people consider appropriate. I may not be around before beta.

None of it is appropriate anymore...

OID wraparound isn't a problem?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#3)
Re: Warning about oid/xid wraparound

Bruce Momjian <pgman@candle.pha.pa.us> writes:

None of it is appropriate anymore...

OID wraparound isn't a problem?

Well, it could be a problem if an app is relying on uniqueness of OIDs
without having installed an unique index on OIDs. However, I do not
think it is the business of the backend to issue nuisance warnings that
will come out whether an app is using unsafe practices or not.

regards, tom lane