Re: [PERFORM] tuning postgresql 9.3.5 and multiple cores

2014-08-26 Thread Mark Kirkwood
On 26/08/14 06:47, Jeison Bedoya Delgado wrote: hi, recently i change the hardware of my database 32 cores up to 64 cores and 128GB Ram, but the performance is the same. Perhaps i have to change any parameter in the postgresql.conf?. In addition to the points that others have made, even if yo

Re: [PERFORM] tuning postgresql 9.3.5 and multiple cores

2014-08-26 Thread Soni M
Changing to a higher rate CPU would be more helpful if you run less than 32 queries at a time. On Tue, Aug 26, 2014 at 8:51 AM, Jeff Janes wrote: > On Monday, August 25, 2014, Jeison Bedoya Delgado < > jeis...@audifarma.com.co> wrote: > >> hi, recently i change the hardware of my database 32 co

Re: [PERFORM] tuning postgresql 9.3.5 and multiple cores

2014-08-25 Thread Jeff Janes
On Monday, August 25, 2014, Jeison Bedoya Delgado wrote: > hi, recently i change the hardware of my database 32 cores up to 64 cores > and 128GB Ram, but the performance is the same. Perhaps i have to change > any parameter in the postgresql.conf?. > PostgreSQL does not (yet) automatically par

[PERFORM] tuning postgresql 9.3.5 and multiple cores

2014-08-25 Thread Jeison Bedoya Delgado
hi, recently i change the hardware of my database 32 cores up to 64 cores and 128GB Ram, but the performance is the same. Perhaps i have to change any parameter in the postgresql.conf?. Thanks by your help -- Atentamente, JEISON BEDOYA DELGADO . -- NOTA VERDE: No imprima este correo a men