Re: Unbounded (Possibly) Database Size Increase - Toasting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Unbounded (Possibly) Database Size Increase - Toasting
Дата
Msg-id 29945.1021829821@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Unbounded (Possibly) Database Size Increase - Toasting  (Mark kirkwood <markir@slingshot.co.nz>)
Ответы Re: Unbounded (Possibly) Database Size Increase - Toasting  (Hannu Krosing <hannu@tm.ee>)
Список pgsql-hackers
Mark kirkwood <markir@slingshot.co.nz> writes:
> However I could not get any size stabilization in the toasted case.

Hmm.  Which file(s) were growing, exactly?  How many row updates is this
run covering?

I'd rather expect the toast indexes to grow given the lack-of-btree-
collapse-logic issue.  However, the rate of growth ought to be pretty
tiny --- much less than the amount of data being pumped through, for
sure.
        regards, tom lane


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pq_eof() broken with SSL
Следующее
От: Tom Lane
Дата:
Сообщение: ScanCommandId should become part of snapshot