Postgres Pro
Downloads
Home   >   mailing lists

Re: tuning postgresql 9.3.5 and multiple cores - Mailing list pgsql-performance

From Jeff Janes
Subject Re: tuning postgresql 9.3.5 and multiple cores
Date
Msg-id CAMkU=1y=r2XkUhiyZc4h2V1iTdR_H60XywHDmUUt2uYVQa8uew@mail.gmail.com
Whole thread Raw
In response to tuning postgresql 9.3.5 and multiple cores  (Jeison Bedoya Delgado <jeisonb@audifarma.com.co>)
Responses Re: tuning postgresql 9.3.5 and multiple cores
List pgsql-performance
Tree view
On Monday, August 25, 2014, Jeison Bedoya Delgado <jeisonb@audifarma.com.co> 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 parallelize queries.

Unless you have more than 32 queries trying to run at the same time, increasing the number of cores from 32 to 64 is unlikely to be useful.

Cheers,

Jeff

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3
Next
From: Mark Kirkwood
Date:
Subject: Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3