From: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | toast table growing indefinitely? Known problems? |
Date: | 2002-12-02 03:23:32 |
Message-ID: | 5.1.0.14.0.20021202140734.0448e7f0@mail.rhyme.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Is there a known problem with TOAST tables growing indefinitely in 7.2?
We have a database that has large text chunks inserted & deleted regularly,
and despite regular vacuums, the toast table continues to grow. We can not
do a VACUUM FULL since it's a 24x7 system, but we do VACUUM frequently.
Based on other threads we have tried using REINDEX on the base table, but
we have confirmed that it is not the toast index table that is the main
consumer, and it does not seem to help.
On a separate issue, we have seen toast indexes growing indefinitely on 7.3
despite VACUUM FULL. Attempting a reindex results in:
# reindex table tt;
WARNING: table "tt" wasn't reindexed
REINDEX
Any help and/or pointers would be appreciated.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2002-12-02 03:36:45 | Re: 7.4 Wishlist |
Previous Message | Tom Lane | 2002-12-02 02:36:51 | Re: Read-only plan trees |