Re: Vacuum suggesting doubling of max_fsm_pages

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum suggesting doubling of max_fsm_pages
Date: 2006-04-27 18:53:06
Message-ID: F1338C6E-C667-488C-8DC6-84F730D6D1FB@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 27, 2006, at 11:06 AM, Kenneth Downs wrote:

> I've got a test database that is going live.
> During development I have not vacuum'd much, so to get started I
> did "Vacuum verbose analyze".

you probably really do have a lot of spare space in the files. i'd
recommend vacuum full if you can, to compact it all since you haven't
done a vacuum regularly.

then after a while of production, see what vacuum recommends for fsm
settings.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Strobhen 2006-04-27 19:03:50 Unexpected behavior
Previous Message Andreas Kretschmer 2006-04-27 18:05:31 Re: CALCULAR EDAD!