From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: TR: Re: Postgres and multiprocessor?
Date: Tue, 28 Apr 2015 09:11:42 -0600
Message-ID: <D94F5A78-2A37-445F-B542-84A7F77EF6AC@elevated-dev.com> (raw)
In-Reply-To: <A17B3B8F1C20994DA3BA17A7C1264BA919AAD3E3@C-SR007-XCH.Techno-dz.com>
References: <A17B3B8F1C20994DA3BA17A7C1264BA919AAD3E3@C-SR007-XCH.Techno-dz.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Apr 28, 2015, at 5:00 AM, Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com> wrote:
>
> J’ai un PostgreSQL installer dans un serveur dell Xeon® Processor E5-2407 (10M Cache, 2.20 GHz), PostgreSQLutilise un cœur de processeur pour ces analyses et sa prendre plus de temps, il y a une possibilité que le PostgreSQL utilise les 4 cœurs à la place d’un cœur (notion de multiprocesseur).
Also, have you checked to see whether your queries are CPU-bound or disk-bound? It’s really more common for disk to be the problem, and regardless there may be tuning that could be done. Try EXPLAIN ANALYZE on the worst queries, then post that here, along with the schema, and notes about db size, and tuning parameters from postgresql.conf.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, Aissa.Bm@techno-dz.com
Subject: Re: TR: Re: Postgres and multiprocessor?
In-Reply-To: <D94F5A78-2A37-445F-B542-84A7F77EF6AC@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox