public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andreas Wagner <[email protected]>
To: [email protected]
Subject: Two server instances on one server
Date: Wed, 10 Apr 2024 22:38:50 +0200
Message-ID: <[email protected]> (raw)

Hello everyone,

I consider using two instances of the PG server on one node. The node
has two processors and each processor has 64GB memory assigned to it.
I'd like to
* restrict instance one to processor 0 and its memory and
* instance two to processor 1 and its memory
using numactl (or similar commands regarding cpuset) and partitioning.
I expect >30% speedup on some queries, because collecting data can be
done in parallel.
Some background information on the system: It's a regular 2 Xeon (each
4x2 cores due to hyperthreading) system with a lot of memory. Memory
assigned to the processor can be accessed quickly, memory assigned to
the OTHER processor is slow.
Does anyone here know a way to accomplish that? I think openstreetmap
map of germany (4GB) is a nice opportunity to test performance.

Looking forward to constructive answers
Andreas Wagner

reply

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Two server instances on one server
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox