| From: | Phillip Berry <pberry(at)stellaconcepts(dot)com> |
|---|---|
| To: | "Grzegorz =?utf-8?q?Ja=C5=9Bkiewicz?=" <gryzman(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Maximum reasonable free space map |
| Date: | 2008-12-17 02:29:33 |
| Message-ID: | 200812171329.33814.pberry@stellaconcepts.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
The data in nearly every table is constantly changing due to a high volume of new data constantly
coming in, processing on the existing data and heavy reporting being done all at once all day and
night.
So I guess my question is, is there a point where you start to see diminishing returns or even
negative returns by setting the fsm too high?
Cheers
Phil
On Wednesday 17 December 2008 13:02:21 Grzegorz Jaśkiewicz wrote:
> On Wed, Dec 17, 2008 at 12:55 AM, Phillip Berry
>
> <pberry(at)stellaconcepts(dot)com> wrote:
> > I thought 185K was pretty high, is going to 700K+ reasonable? I've got
> > 16GB of ram and am running very high volume 100GB+ DBs.
>
> all depends on how often does the data change. I would go with
> whatever vacuum is suggesting on production :)
> in 8.4 you won't have to worry about it anymore anyway ;)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaśkiewicz | 2008-12-17 02:52:44 | Re: Maximum reasonable free space map |
| Previous Message | Grzegorz Jaśkiewicz | 2008-12-17 02:02:21 | Re: Maximum reasonable free space map |