From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Kamil Srot <kamil(dot)srot(at)nlogy(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Tables dissapearing |
Date: | 2007-08-27 17:04:28 |
Message-ID: | 20070827170428.GE5353@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Aug 27, 2007 at 06:57:54PM +0200, Kamil Srot wrote:
> Correct...the script does echo "vacuum full;" | $PGDIR/bin/psql -U
> postgres $db for each database...
> Hope it's correct?
Well, I'd drop the "full" part, it tends to bloat indexes. Also, did
you check it was actually completing (no errors)?
> Maybe it's it... I did check the wraparound with:
> SELECT datname, age(datfrozenxid) FROM pg_database;
>
> In your SQL I see several rows with too high numbers!
>
> They are all "internal" like pg_toast_618854, views and also some
> application level indices etc.
Depends what you mean by too high. Anything with XID 1 and 2 is not a
problem, and age returns a really big number for them. Can you give
some examples?
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-08-27 17:04:39 | Re: PostgreSQL vs Firebird feature comparison finished |
Previous Message | Michael Glaesemann | 2007-08-27 17:04:10 | Re: PostgreSQL vs Firebird feature comparison finished |