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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
