How to compress FM database

[Chetan R]

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.

[Vu Phan]

Hello Chetan,

The vacum command is only support PostgresSQL

Thanks

[Chetan R]

Hello Vu Phan

Thank you for your reply,

Yes its a PostgresSQL database used in the environment

Please let me know the vaccum command

[Vu Phan · Accepted solution]

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)