This is a multi-part message in MIME format.
------_=_NextPart_001_01CA6219.8EE64A5A
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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
------_=_NextPart_001_01CA6219.8EE64A5A
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7654.12">
<TITLE>8.4 auto vacuum</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">Tomorrow I will be migrating from =
PostgreSQL 8.2 to 8.4. </FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">In PostgreSQL 8.2 in order for vacuum =
to work I had to bump up max_fsm_pages to 1924288. </FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">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.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2) If auto vacuum has issues in 8.4 =
will PostgreSQL tell me what settings to tweak like it did in =
8.2?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Lance Campbell</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Project Manager/Software =
Architect/DBA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Web Services at Public Affairs</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">217-333-0382</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01CA6219.8EE64A5A--
