From: | Soni M <diptatapa(at)gmail(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | Jeison Bedoya Delgado <jeisonb(at)audifarma(dot)com(dot)co>, "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 09:50:15 |
Message-ID: | CAAMgDXkzcH9EwTG5CUT81_UZORbAY2H6kGzh57ZC4HO0556z9A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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 <jeff(dot)janes(at)gmail(dot)com> wrote:
> 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
>
--
Regards,
Soni Maula Harriz
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2014-08-26 10:10:12 | Re: tuning postgresql 9.3.5 and multiple cores |
Previous Message | Mark Kirkwood | 2014-08-26 02:03:53 | Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 |