From: | adey <adey11(at)gmail(dot)com> |
---|---|
To: | "amar buwa" <amar(dot)buwa(at)hovservices(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How do I adjust max_fsm_pages |
Date: | 2006-11-07 08:01:55 |
Message-ID: | 1c66bda80611070001n725c0b5ey4495cc1ece403b30@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
When last did you do a FULL vacuum and analyse the stats report at the end?
On 1/2/90, amar buwa <amar(dot)buwa(at)hovservices(dot)com> wrote:
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kuckuck Kuckuck | 2006-11-07 10:36:54 | Problems changing column attribute |
Previous Message | Tom Lane | 2006-11-07 04:52:34 | Re: Out of Memory |