How do I adjust max_fsm_pages - Mailing list pgsql-admin

From amar buwa
Subject How do I adjust max_fsm_pages
Date
Msg-id 259FE5D6.7030203@hovservices.com
Whole thread Raw
Responses Re: How do I adjust max_fsm_pages
List pgsql-admin
Hi,
      My postgresql configuration is

  max_locks_per_transaction = 256
   max_connections = 200
   shared_buffers = 6000
   max_fsm_pages = 200000
   max_fsm_relations = 1500

  My serversers total RAM=32GB

      Still I am not able to insert more than 10million records, its
taking lot of time. It also gives hint to increse max_fsm_pages.
 So Please suggest me how do I adjust above parameters to avoid errors
and to increase postgres speed performance?

Thanks ,
Amar


pgsql-admin by date:

Previous
From: Jeff Frost
Date:
Subject: error: markets_pk is an index
Next
From: Nikola Radakovic
Date:
Subject: Memory space