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

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: db size growing out of control when using clustered Jackrabbit
Дата
Msg-id CAOR=d=3AJ4GXn8+_E_VrNxyNzqE8_8a4Nt6taexT2ZHuV6FZJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: db size growing out of control when using clustered Jackrabbit  (Gary Webster <webster@lexmark.com>)
Список pgsql-admin
On Thu, Jul 26, 2012 at 1:31 PM, Gary Webster <webster@lexmark.com> wrote:
> OK, I set "log_statement = "all""
> The log grew to 1GB in ~minute!  It is dominated by this one statement,
> which occurs every ~1.4 sec:
> "update WS_BUNDLE set BUNDLE_DATA = $1 where NODE_ID_HI = $2 and NODE_ID_LO
> = $3"
> parameter $1 is hex, over 6million characters long !!   Surely this is the
> root of my problem.

That's crazy big.  Is that a normal payload size for this app?

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

Предыдущее
От: Gary Webster
Дата:
Сообщение: Re: db size growing out of control when using clustered Jackrabbit
Следующее
От: Alanoly Andrews
Дата:
Сообщение: pg_dump on Postgres 9.1