On Mon, Dec 26, 2005 at 04:11:49PM -0500, Jaime Casanova wrote: > yes, it seems that's enough... > > i was trying to help to a buddy in the spanish list and my first > recommendation was to copy all data directory... when he tries that he > makes a vacuum and the data go back... > > i told him to review their data to be sure... For the record, the data dissappears from view after 2 billion transactions but it's not until 3 billion that VACUUM considers the data in the future and thus removable. VACUUM fixes it so it appears again and all is well. The only issue I can think of is that constraints might be violated (duplicate keys in unique index) because one of the records might have been invisible when the second was created... Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment:
pgpWkyRrOTm4N.pgp
Description: PGP signature
