Re: Unbounded (Possibly) Database Size Increase - Toasting - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Unbounded (Possibly) Database Size Increase - Toasting
Date
Msg-id 29945.1021829821@sss.pgh.pa.us
Whole thread Raw
In response to Re: Unbounded (Possibly) Database Size Increase - Toasting  (Mark kirkwood <markir@slingshot.co.nz>)
Responses Re: Unbounded (Possibly) Database Size Increase - Toasting  (Hannu Krosing <hannu@tm.ee>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pq_eof() broken with SSL
Next
From: Tom Lane
Date:
Subject: ScanCommandId should become part of snapshot