How do I adjust max_fsm_pages

From: amar buwa <amar(dot)buwa(at)hovservices(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How do I adjust max_fsm_pages
Date: 1990-01-01 23:20:54
Message-ID: 259FE5D6.7030203@hovservices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message amar buwa 1990-01-02 19:17:01 Re: How do I adjust max_fsm_pages
Previous Message Ladislav Jirsa 0102-03-15 14:46:26 problems with dbf-files