Re: Interpreting vacuum verbosity

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Interpreting vacuum verbosity
Date: 2004-05-07 18:29:01
Message-ID: 200405071229.01168.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday May 7 2004 12:23, Ed L. wrote:
> On Friday May 7 2004 12:20, Ed L. wrote:
> > 1) I'm inclined to set this to handle as large a DB footprint as will
> > be in the coming year or two, so maybe 3X what it is now. What is the
> > impact/cost of setting max_fsm_pages at, say, 3M for an 8GB footprint?
> > (3 x 8GB/8K)
>
> Ok, so I see 40B per, so setting it to 3M ==> 3M * 40 = 120MB of
> additional RAM usage for this? Any other impacts with which to be
> concerned?

Sorry, I see that's *6B* per, so setting it to 3M ==> 18MB, which is trivial
for the benefit. Any other concerns in setting this too high?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-05-07 18:44:01 Re: Interpreting vacuum verbosity
Previous Message Ed L. 2004-05-07 18:23:02 Re: Interpreting vacuum verbosity