UnUsed Tuple Space Huge

From: "Michael G(dot) Martin" <michael(at)vpmonline(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: UnUsed Tuple Space Huge
Date: 2002-06-12 22:21:12
Message-ID: 3D07C958.5090908@vpmonline.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

From what I understand, the new vacuum will mark deleted tuples as
unused and try to re-use the space if possible. However, I seem to have
a huge amount of UnUsed tuples on some large tables. The table is
updated 1x each day followed by a vacuum analyze.

Any idea why the huge UnUsed tuples. Performance decreases and indexes
stop being used in favor of full table scans.

VACUUM verbose symbol_Data;
NOTICE: --Relation symbol_data--
NOTICE: Pages 767990: Changed 0, Empty 0; Tup 21595176: Vac 0, Keep 0,
UnUsed 16560877.
Total CPU 61.94s/6.94u sec elapsed 179.25 sec.
VACUUM

I'm thinking I may just have to copy/rename periodically to keep it down.

This was on psql (PostgreSQL) 7.2rc2. Will upgrade to 7.2.1, but didn't
see anything in the Changelogs/History to indicate anything will change.

Thanks,
Michael

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message edison 2002-06-12 22:22:21 database testing
Previous Message Laurette Cisneros 2002-06-12 22:03:29 removing a user who owns objects