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

From Rod Taylor
Subject Re: toast table growing indefinitely? Known
Date
Msg-id 1038861401.46704.86.camel@jester
Whole thread Raw
In response to Re: toast table growing indefinitely? Known  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> > I've increased the value to 40000 since we have much busier days, and I'll
> > se what happens.
>
> 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?  Why
> don't we introduce:  max_fsm_pages = auto or something?

I assume it uses shared memory, so I doubt it's very easy to increase on
the fly -- without having to reduce something else anyway.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-hackers by date:

Previous
From: "Magnus Naeslund(f)"
Date:
Subject: Re: 7.4 Wishlist
Next
From: Robert Treat
Date:
Subject: Re: protecting prosrc (was Re: [GENERAL] USAGE on schema allowed by