Re: Disappearing Records
| От | Venki |
|---|---|
| Тема | Re: Disappearing Records |
| Дата | |
| Msg-id | 4369A781.000001.01340@VENKI обсуждение исходный текст |
| Ответ на | Re: Disappearing Records (Martijn van Oosterhout <kleptog@svana.org>) |
| Список | pgsql-general |
Hi Martijn van Oosterhout , This is the output that I get by running the query SELECT datname, age(datfrozenxid) FROM pg_database; datname | age ----------------+---------- MyProd | 10014107 MyProdtest | 10014107 template1 | 10014107 template0 | 10014107 MyDb | 10014107 (5 rows) Regards Venki -------Original Message------- From: Martijn van Oosterhout Date: 11/02/05 17:47:26 To: Venki Subject: Re: [GENERAL] Disappearing Records On Wed, Nov 02, 2005 at 05:00:35PM +0530, Venki wrote: > >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? VACUUM cannot recover data from transaction wraparound. But we havn't even determined if this has happened as you have not yet posted the output of this query: SELECT datname, age(datfrozenxid) FROM pg_database; Have a ncie day, -- Martijn van Oosterhout <kleptog@svana.org> 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. | |||
В списке pgsql-general по дате отправления: