Srini Raghavan wrote: > Thank you very much for reviewing, appreciate the feedback.? As pointed out > by > you, it is always best to test it out with the latest version, so, I tested > the > same approach with postgres 9.0.2 on windows just now, and it works! > > > I forgot to mention earlier that in addition to setting > vacuum_freeze_table_age > to 0, vacuum_freeze_min_age must also be set to 0 to reset xmin with the > FrozenXid.
I wonder if you should be using VACUUM FREEZE instead of having to set variables. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers