Re: toast table growing indefinitely? Known - Mailing list pgsql-hackers

From Tom Lane
Subject Re: toast table growing indefinitely? Known
Date
Msg-id 20724.1038897245@sss.pgh.pa.us
Whole thread Raw
In response to Re: toast table growing indefinitely? Known  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.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


pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Shrinkwrap Windows Product, any issues? Anyone?
Next
From: Tom Lane
Date:
Subject: Re: 7.4 Wishlist