Re: Unbounded (Possibly) Database Size Increase - Toasting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark kirkwood <markir(at)slingshot(dot)co(dot)nz>
Cc: Hannu Krosing <hannu(at)tm(dot)ee>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Unbounded (Possibly) Database Size Increase - Toasting
Date: 2002-05-19 17:37:01
Message-ID: 29945.1021829821@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Mark kirkwood <markir(at)slingshot(dot)co(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jean-Michel POURE 2002-05-19 18:08:18 Re: [HACKERS] UTF-8 safe ascii() function
Previous Message Peter Eisentraut 2002-05-19 15:17:12 Re: pq_eof() broken with SSL