Re: db size growing out of control when using clustered Jackrabbit

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: db size growing out of control when using clustered Jackrabbit
Дата
Msg-id 500DEDC7.3000402@ringerc.id.au
обсуждение исходный текст
Ответ на db size growing out of control when using clustered Jackrabbit  (Gary Webster <webster@lexmark.com>)
Ответы Re: db size growing out of control when using clustered Jackrabbit  (Gary Webster <webster@lexmark.com>)
Список pgsql-admin
Дерево обсуждения
On 07/24/2012 05:13 AM, Gary Webster wrote:
Hello. I'm hoping someone has seen this before.

We are trying to use Postgres Plus v9.1.3 as the Persistence Manager in Jackrabbit (Apache JCR) clustering (http://wiki.apache.org/jackrabbit/Clustering).
Whenever the JCR is under load, the ws_bundle TOAST table in the  repository  schema, grows out of control !

Has somebody disabled autovacuum or set it to barely run at all?

Try setting autovacuum to very aggressively vacuum the problem table(s).

--
Craig Ringer

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: db size growing out of control when using clustered Jackrabbit
Следующее
От: Gary Webster
Дата:
Сообщение: Re: db size growing out of control when using clustered Jackrabbit