pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTR: Re: Postgres and multiprocessor?
4+ messages / 3 participants
[nested] [flat]
* TR: Re: Postgres and multiprocessor?
@ 2015-04-28 11:00 Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com>
0 siblings, 3 replies; 4+ messages in thread
From: Aissa BAMMOUNE IT @ 2015-04-28 11:00 UTC (permalink / raw)
To: pgsql-admin
Salut
Jai un PostgreSQL installer dans un serveur dell Xeon® Processor E5-2407 (10M Cache, 2.20 GHz), PostgreSQL utilise un cur de processeur pour ces analyses et sa prendre plus de temps, il y a une possibilité que le PostgreSQL utilise les 4 curs à la place dun cur (notion de multiprocesseur).
MERCI DAVANCE.
| Aissa BAMMOUNE
| Ingénieur Technico-Fonctionnel ERP
[cid:image001.png@01D081A7.E5616030] 05 61 79 13 06
| Aissa.bm@techno-dz.com<mailto:Aissa.bm@techno-dz.com>
Attachments:
image001.png (image/png, 3.8K) download
view image
* Re: TR: Re: Postgres and multiprocessor?
@ 2015-04-28 15:08 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com>
2 siblings, 0 replies; 4+ messages in thread
From: Scott Ribe @ 2015-04-28 15:08 UTC (permalink / raw)
To: Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com>; +Cc: pgsql-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).
1 core per query.
PostgreSQL scales across cores well for handling multiple concurrent queries, but does not use multiple cores for a single query.
--
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: TR: Re: Postgres and multiprocessor?
@ 2015-04-28 15:11 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com>
2 siblings, 0 replies; 4+ messages in thread
From: Scott Ribe @ 2015-04-28 15:11 UTC (permalink / raw)
To: Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: TR: Re: Postgres and multiprocessor?
@ 2015-04-28 15:13 Alvaro Herrera <alvherre@2ndquadrant.com>
parent: Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com>
2 siblings, 0 replies; 4+ messages in thread
From: Alvaro Herrera @ 2015-04-28 15:13 UTC (permalink / raw)
To: Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com>; +Cc: pgsql-admin
Aissa BAMMOUNE IT wrote:
>
>
> Salut
>
> J’ai un PostgreSQL installer dans un serveur dell Xeon® Processor E5-2407 (10M Cache, 2.20 GHz), PostgreSQL utilise 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).
>
> MERCI D’AVANCE.
Non. Merci d'utiliser la liste de diffusion pgsql-fr-generale pour
obtenir de l'aide en français, y compris une réponse détaillée à votre
question.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2015-04-28 15:13 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-04-28 11:00 TR: Re: Postgres and multiprocessor? Aissa BAMMOUNE IT <Aissa.Bm@techno-dz.com>
2015-04-28 15:08 ` Scott Ribe <scott_ribe@elevated-dev.com>
2015-04-28 15:11 ` Scott Ribe <scott_ribe@elevated-dev.com>
2015-04-28 15:13 ` Alvaro Herrera <alvherre@2ndquadrant.com>
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