From: | "Venki" <Venki(at)insoft(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Disappearing Records |
Date: | 2005-11-03 06:00:33 |
Message-ID: | 4369A781.000001.01340@VENKI |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
Cc: pgsql-general(at)postgresql(dot)org
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(at)svana(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2005-11-03 06:14:26 | Re: Built in function question |
Previous Message | Tony Caduto | 2005-11-03 05:10:22 | Re: Built in function question |