Martijn van Oosterhout <kleptog@xxxxxxxxx> 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
