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:23:02
Message-ID: 200405071223.02725.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2004-05-07 18:29:01 Re: Interpreting vacuum verbosity
Previous Message Jeff Boes 2004-05-07 18:22:40 Re: Interpreting vacuum verbosity