Re: toast table growing indefinitely? Known

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: "Philip Warner" <pjw(at)rhyme(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: toast table growing indefinitely? Known
Date: 2002-12-03 06:34:05
Message-ID: 20724.1038897245@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> Hang on - so when vacuum runs it knows exactly how many pages it cleaned up
> but if the fsm value is low, it doesn't help? Why don't we just
> automaticlaly set the FSM value to the max that vacuum has to clean
> up?

Because we can't resize shared memory on-the-fly.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-12-03 06:52:57 Re: Segmentation fault while COPY in 7.3
Previous Message mlw 2002-12-03 06:17:23 Shrinkwrap Windows Product, any issues? Anyone?