Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

How to compress FM database

Hello

How to compress FM database.

FM 4.2(7b) is used with Postgres, and the database is currently at 11.2 gigs.

Is it true that there is a vacuum command that can be run against SQL dbs.

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

How to compress FM database

Hello Chetan,

Here is how to compress PostgresSQL

FM Server is running slow with Postgres.

Please check database size ($INSTALLDIR/dcm/db/data), size should be less than 3 GB. (On windows, right-mouse click on “data” folder and select “properties” menu item, a dialog will pop up and display folder size. On linux/solaris, just run “du –k $INSTALLDIR/dcm/db/data.” command)

Run the following command to reduce size:

1.Stop FMServer.

      2. cd $POSTGRES_DIR/bin

      3. run ./psql.exe –U db_username dcmdb (where dcmdb is the database name)

      4.run this command at psql prompt.

                #vacuum full analyze verbose;

                #\q

      5. You should see database size is reduced. (The above might take a while)

Change the following parameter inpostgresql.conf to slow down the growth. Here is the instruction:

1. stop postgresql services

      2. edit $INSTALLDIR/db/data/postgresql.conf

      Change following parameter:

      checkpoint_segments = 6        

      max_fsm_pages = 532000

shared_buffers = 128MB

temp_buffers = 32MB

work_mem = 4MB

maintenance_work_mem = 16MB

max_fsm_pages = 532000

log_min_duration_statement = 200

      3. Restart postgresql services. (remove first '#' if it is there)

3 REPLIES
Cisco Employee

How to compress FM database

Hello Chetan,

The vacum command is only support PostgresSQL

Thanks

New Member

How to compress FM database

Hello Vu Phan

Thank you for your reply,

Yes its a PostgresSQL database used in the environment

Please let me know the vaccum command

Cisco Employee

How to compress FM database

Hello Chetan,

Here is how to compress PostgresSQL

FM Server is running slow with Postgres.

Please check database size ($INSTALLDIR/dcm/db/data), size should be less than 3 GB. (On windows, right-mouse click on “data” folder and select “properties” menu item, a dialog will pop up and display folder size. On linux/solaris, just run “du –k $INSTALLDIR/dcm/db/data.” command)

Run the following command to reduce size:

1.Stop FMServer.

      2. cd $POSTGRES_DIR/bin

      3. run ./psql.exe –U db_username dcmdb (where dcmdb is the database name)

      4.run this command at psql prompt.

                #vacuum full analyze verbose;

                #\q

      5. You should see database size is reduced. (The above might take a while)

Change the following parameter inpostgresql.conf to slow down the growth. Here is the instruction:

1. stop postgresql services

      2. edit $INSTALLDIR/db/data/postgresql.conf

      Change following parameter:

      checkpoint_segments = 6        

      max_fsm_pages = 532000

shared_buffers = 128MB

temp_buffers = 32MB

work_mem = 4MB

maintenance_work_mem = 16MB

max_fsm_pages = 532000

log_min_duration_statement = 200

      3. Restart postgresql services. (remove first '#' if it is there)

624
Views
0
Helpful
3
Replies
CreatePlease login to create content