Re: migrating from 8.1.x to 8.2

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