Chris Browne wrote: > Would the following 'maintenance' regimen be truly safe against XID > wraparound: > > - Most tables are being vacuumed regularly, so that > pg_class.relfrozenxid is kept "safe." > > - There are some tables that periodically get TRUNCATEd so that, in > principle, they never need to be vacuumed. > > Is it actually true that we'd never need to vacuum those tables > (assuming 8.2+)? I suppose it would be rather cheap to VACUUM > immediately after the TRUNCATE...
You'd need to vacuum after the truncate. It would be pretty cheap, the tables being empty. I suppose it would be pretty trivial to set the relfrozenxid to RecentXmin or something during TRUNCATE. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
