Re: PostgreSQL on SMP Architectures

From: Kevin Grittner
Subject: Re: PostgreSQL on SMP Architectures
Date: ,
Msg-id: 4B7906C7020000250002F2D8@gw.wicourts.gov
(view: Whole thread, Raw)
In response to: PostgreSQL on SMP Architectures  (Reydan Cankur)
List: pgsql-performance

Tree view

PostgreSQL on SMP Architectures  (Reydan Cankur, )
 Re: PostgreSQL on SMP Architectures  (Arjen van der Meijden, )
 Re: PostgreSQL on SMP Architectures  (Scott Marlowe, )
  Re: PostgreSQL on SMP Architectures  (Reydan Cankur, )
   Re: PostgreSQL on SMP Architectures  (Boszormenyi Zoltan, )
 Re: PostgreSQL on SMP Architectures  ("Kevin Grittner", )

Reydan Cankur  wrote:

> I want to spread out the workload on all cores. But also I want to
> set the core number; for example first I want to spread out the
> workload to 32 cores then 64 cores and see the scalability.

PostgreSQL itself won't use more cores than you have active
connections, so one way to deal with this might be to use one of the
available connection poolers, like pgpool or pgbouncer.  That should
allow you to control the number of cores used pretty well, although
it won't support targeting particular connections to particular
cores (although this technique could be combined with other
suggestions).  The OS might use another core or two to help with
network or disk I/O, but that should be minimal.

-Kevin


pgsql-performance by date:

From: "Rose Zhou"
Date:
Subject: Auto Vacuum out of memory
From: Ben Chobot
Date:
Subject: Re: disk space usage unexpected