Re: Tables dissapearing

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.