Re: Ever increasing OIDs - gonna run out soon?

Martijn van Oosterhout <kleptog@svana.org> writes:
> Well, you have to be using a lot of OIDs for this to be an issue. At
> your stated rate of 1.5 million OIDs per day it will take just under
> eight years before you wraparound. That's a lot of OIDs and most
> databases don't get anywhere near that many, which is why it's not a
> big deal for most people...

It should also be pointed out that OID wraparound is not a fatal
condition.  Pre-8.1 you might get occasional query failures due to
trying to insert duplicate OIDs, but that's about it.

> This gives you a list of tables that use OIDs. Maybe it can help you
> track down the problem.

Look at pg_class.relhasoids --- easier, and more reliable.

            regards, tom lane