Re: Unbounded (Possibly) Database Size Increase - Toasting

Hannu Krosing <hannu(at)tm(dot)ee> writes:
> On Sun, 2002-05-19 at 19:37, Tom Lane wrote:
>> 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 ?

Well, the toast indexes will grow because they're using an OID key,
and so the range of indexed values keeps increasing. AFAIR Mark didn't
say whether he *had* a primary key, let alone what it was --- but it's
possible that he has one that has a range that's not changing over the
test.

In particular, if the test consists simply of updating the toasted
field, that will not change the primary keys at all ... but it will
change the toast table's key range, because each new value will get
a new toast OID.

regards, tom lane