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

From Hannu Krosing
Subject Re: Unbounded (Possibly) Database Size Increase - Toasting
Date
Msg-id 1021904879.14280.224.camel@taru.tm.ee
Whole thread Raw
In response to Re: Unbounded (Possibly) Database Size Increase - Toasting  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unbounded (Possibly) Database Size Increase - Toasting  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: SASL, compression?
Next
From: "Dave Page"
Date:
Subject: Re: More schema queries