Home > Archive > Slony1 PostgreSQL Replication > August 2005 > OIDs on Slony tables









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author OIDs on Slony tables
Ian Burrell

2005-08-08, 1:27 pm

Is there any problem with doing ALTER TABLE SET WITHOUT OIDS on the
tables in the slony schema? Are there any problems with doing SET
WITHOUT OIDS on user tables?

We have been having issues with OID wraparound causing failures. To
slow the consumption of OIDS, we are going to do SET WITHOUT OIDS on
all user tables. Since Slony doesn't use OIDs except to refer to the
catalog, I don't think this will cause any problems.

The sl_log_1 table also consumes lots of OID values. I wouldn't think
SET WITHOUT OIDS would cause any issues but I wanted to make sure.

- Ian
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com