Thread: Vacuum Issue 8.2
Postgresql 8.2
When I do a full vacuum of our database I get the following:
NOTICE: relation "pg_class" TID 23/39: DeleteTransactionInProgress 4060299835 --- can't shrink relation
NOTICE: relation "pg_class" TID 31/31: InsertTransactionInProgress 4060299835 --- can't shrink relation VACUUM
What does this mean?
Thanks,
Lance Campbell
Project Manager/Software Architect/DBA
Web Services at Public Affairs
217-333-0382
Campbell, Lance wrote: > Postgresql 8.2 > > When I do a full vacuum of our database I get the following: > > NOTICE: relation "pg_class" TID 23/39: DeleteTransactionInProgress > 4060299835 --- can't shrink relation > NOTICE: relation "pg_class" TID 31/31: InsertTransactionInProgress > 4060299835 --- can't shrink relation VACUUM > > What does this mean? Internal affairs. Ignore it. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support