toast table growing indefinitely? Known problems?
От | Philip Warner |
---|---|
Тема | toast table growing indefinitely? Known problems? |
Дата | |
Msg-id | 5.1.0.14.0.20021202140734.0448e7f0@mail.rhyme.com.au обсуждение исходный текст |
Ответы |
Re: toast table growing indefinitely? Known problems?
|
Список | 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 |/
В списке pgsql-hackers по дате отправления: