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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: db size growing out of control when using clustered Jackrabbit
Дата
Msg-id 24028.1343149715@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: db size growing out of control when using clustered Jackrabbit  (Gary Webster <webster@lexmark.com>)
Список pgsql-admin
Gary Webster <webster@lexmark.com> writes:
> By "routine maintenance", do you mean autovacuum, or something else?
> Autovacuum does appear to usually get 'auto-canceled' by a lock.

That's bad and you should look into the reason why it happens.  Ordinary
DML (CRUD) operations should not kick autovac off a table.  If it's
happening, it's probably because something is fooling with the table's
schema, which doesn't seem like something you want to have happening
during routine operations; especially not on tables that are large
enough for this to be an issue in the first place.  Or it might be
something doing a LOCK TABLE as a substitute for more fine-grained
locking; which again is bad for performance reasons that have nothing
to do with hobbling autovacuum.

            regards, tom lane

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

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