Re: tuning postgresql 9.3.5 and multiple cores

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Jeison Bedoya Delgado <jeisonb(at)audifarma(dot)com(dot)co>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: tuning postgresql 9.3.5 and multiple cores
Date: 2014-08-26 01:51:35
Message-ID: CAMkU=1y=r2XkUhiyZc4h2V1iTdR_H60XywHDmUUt2uYVQa8uew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Monday, August 25, 2014, Jeison Bedoya Delgado <jeisonb(at)audifarma(dot)com(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2014-08-26 02:03:53 Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3
Previous Message Josh Berkus 2014-08-25 22:13:59 Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3