-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Lonni Friedman wrote: |>>Then nothing for a month after going to 7.3.4, and now its happening |>>every vacuumdb run again. |>Once the complaint starts appearing, I'd expect it to continue until you |>reindex the index. | That's exactly what happens. It consistantly errors until reindexed. | Any suggestions? thanks.
A long shot, but we experienced a similar kind of issue, though our dataset was a bit different (not so many large objects). After having reindexed a couple of times with about the same results (working fine for some time, then complaining again), I dropped the index and recreated it. That seemed to fix the issue at our installation, we had no such problems after that. Ran for some months after that before I took the plunge and moved to 7.4..
This might not at all work for you though, and as removing the index will probably kill your performance for a while I cannot promise you a fix with this workaround..
Best Regards - -- Denis -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-nr2 (Windows XP)
iD8DBQFAmqdovsCA6eRGOOARAptYAJ0YF6+tGtyA55hqOf8UaF+q2JnN4wCfdQtV r4nBoDljvFDGlXh3OhNSPcM= =6xLx -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
