Postgres Pro
Downloads
Home   >   mailing lists

8.4 auto vacuum - Mailing list pgsql-admin

From Campbell, Lance
Subject 8.4 auto vacuum
Date
Msg-id B10E6810AC2A2F4EA7550D072CDE876004B2DE60@SAB-FENWICK.sab.uiuc.edu
Whole thread Raw
Responses Re: 8.4 auto vacuum  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view

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?

Thanks,

Lance Campbell
Project Manager/Software Architect/DBA
Web Services at Public Affairs
217-333-0382

pgsql-admin by date:

Previous
From: nw@hydaspes.if.org
Date:
Subject: Re: I need to find all of the unique characters within a text field
Next
From: Scott Marlowe
Date:
Subject: Re: 8.4 auto vacuum