Anj Adu escribió: > We plan to migrate from 8.1.X to 8.2 . I understand that XID > wraparound has changed with the 8.2 release (maintained per table > versus entire database). XID wraparound is important for us as we have > large databases (800Gb +) and also use lot of partitioned inherited > tables. > > Is XID tracking done per inherited table (independent of parent?) ...
Yes, partitions are considered separate tables for this. > If a parent table is just a dummy to implement partition..do we need > to worry about XID wraparound for this table (assuming no data makes > it to this physical table) The parent table will need to be vacuumed once every 2 billion transactions or whatever your settings say, but since the table is empty anyway it shouldn't matter much. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
