Re: Unbounded (Possibly) Database Size Increase - Toasting

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Unbounded (Possibly) Database Size Increase - Toasting
Дата
Msg-id 1021904879.14280.224.camel@taru.tm.ee
обсуждение исходный текст
Ответ на Re: Unbounded (Possibly) Database Size Increase - Toasting  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Unbounded (Possibly) Database Size Increase - Toasting  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sun, 2002-05-19 at 19:37, Tom Lane wrote:
> 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. 

Why sould the toast indexes grow significantly more than the primary key
of main table ?

> However, the rate of growth ought to be pretty
> tiny --- much less than the amount of data being pumped through, for
> sure.

----------
Hannu




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

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: SASL, compression?
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: More schema queries