Hi, >The really nasty thing about it is that because the records are now >considered really old, as soon as you do run VACUUM it'll start >removing the rows you want to save... So does this mean that when we do a vacuum for the first time there will still be data loss or Am I wrong in this? regards Venki -------Original Message------- Date: 11/02/05 17:09:45 Subject: Re: [GENERAL] Disappearing Records On Wed, Nov 02, 2005 at 07:40:29AM +0000, John Sidney-Woollett wrote: > If you have suffered data loss for this reason, then you'll need to get > help from the developers to see whether it can be recovered, or what you > can do to reconstruct the data. The really nasty thing about it is that because the records are now considered really old, as soon as you do run VACUUM it'll start removing the rows you want to save... What you need is a tool to go through and change any transaction ID significantly in the future and freeze it... You know, like VACUUM... Oh well.. In 8.1 autovacuum will make this kind of thing obsolete. Have a nice day. -- > 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. |