| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
| Cc: | markir(at)slingshot(dot)co(dot)nz, Hannu Krosing <hannu(at)tm(dot)ee>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Unbounded (Possibly) Database Size Increase - Toasting |
| Date: | 2002-05-21 17:06:56 |
| Message-ID: | 21649.1022000816@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> Here I'm lost. The effect you mention explains growth up to a state
> where each toast table page holds 3 instead of 4 tuples (1.33 *
> initial size). Now with each UPDATE we get pages with significantly
> more free space than 2K.
Good point, it should still stabilize with at worst 33% overhead. So
maybe I'm barking up the wrong tree.
Still, the FSM code is new in 7.2 and I'm quite prepared to believe that
the effect Mark is seeing indicates some problem in it. Anyone care to
sit down and read through freespace.c? It's pretty liberally commented.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2002-05-21 17:24:41 | Re: Redhat 7.3 time manipulation bug |
| Previous Message | Manfred Koizar | 2002-05-21 16:48:53 | Re: Unbounded (Possibly) Database Size Increase - Toasting |