| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: 8.4 auto vacuum |
| Date: | 2009-11-10 16:53:00 |
| Message-ID: | dcc563d10911100853q6f8adfcfxca02431668b5ebea@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, Nov 10, 2009 at 8:22 AM, Campbell, Lance <lance(at)illinois(dot)edu> wrote:
> Tomorrow I will be migrating from PostgreSQL 8.2 to 8.4.
>
> In PostgreSQL 8.2 in order for vacuum to work I had to bump up max_fsm_pages
> to 1924288.
>
> 1) In PostgreSQL 8.4 do I need to make any changes to the default settings
> for auto vacuum in order for it to run properly? I noticed it does not have
> a setting for max_fsm_pages.
>
> 2) If auto vacuum has issues in 8.4 will PostgreSQL tell me what settings to
> tweak like it did in 8.2?
The basic gist is that in 8.4 the free space map is dynamic and needs
no tweaking. I haven't exercised 8.4 in a busy production environment
so I can't say it definitely works, but so far I've seen no reports of
it NOT working...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anj Adu | 2009-11-10 18:30:14 | postgres 8.4 autovacuum and XID wraparound |
| Previous Message | Campbell, Lance | 2009-11-10 15:22:04 | 8.4 auto vacuum |