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 <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +