Bug 684049

Summary: Postgres Configuration Needs Clarification
Product: [Other] RHQ Project Reporter: George <george.belden>
Component: DocumentationAssignee: Deon Ballard <dlackey>
Status: CLOSED CURRENTRELEASE QA Contact: Mike Foley <mfoley>
Severity: medium Docs Contact:
Priority: medium    
Version: unspecifiedCC: ian.springer, mazz, rbuck
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-06-06 15:50:56 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 678340    

Description George 2011-03-10 23:36:17 UTC 
Description of problem:
The postgresql.conf configuration example shows that you can set the max_fsm_pages property, but this is no longer applicable as of postgres 8.4.  In fact, postgres will not start up if you try to set this property.

Version-Release number of selected component (if applicable): 2.4

How reproducible:
http://docs.redhat.com/docs/en-US/JBoss_Operations_Network/2.4/html-single/Installation_Guide/index.html#Database-Postgres_Preparation

Steps to Reproduce:
1. Go to the URL above
2. Scroll down slightly to section 2.1.1.2.1
3. The example says to set max_fsm_pages = 100000 
  
Actual results:
The user is led to believe they can set max_fsm_pages in postgresql.conf.

Expected results:
Either remove the mas_fsm_pages property or specify that it only applies to postgres 8.3 and earlier.

Additional info:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

"The FSM was rewritten for PostgreSQL 8.4, so earlier advice is no longer applicable. The max_fsm_pages and max_fsm_relations settings are gone, as the new FSM is self-adapting (more info). autovacuum is enabled by default and should remain so, as vacuum much less invasive in 8.4 than before thanks to visibility maps."
Comment 1 John Mazzitelli 2011-03-25 18:33:56 UTC 
making sure this blocks on rhq4 so we remember do change this in the RHQ wiki docs
Comment 2 Ian Springer 2011-04-01 14:04:39 UTC 
I've updated the RHQ docs (http://www.rhq-project.org/display/JOPR2/PostgreSQL#PostgreSQL-postgresql.conf)
Comment 3 Deon Ballard 2011-09-28 16:41:10 UTC 
This is in the 3.0 docs:

http://docs.redhat.com/docs/en-US/JBoss_Operations_Network/3.0/html/Installation_Guide/JON_Server_Installation.html#setting-postgres-settings

I also have it in the 2.4 docs; I just need to update the public build:

http://docs.redhat.com/docs/en-US/JBoss_Operations_Network/2.4/html/Installation_Guide/JON_Server_Installation.html#setting-postgres-settings
Comment 4 Robert Buck 2011-11-29 17:07:19 UTC 
Reviewed