From: | Andreas Wagner <thewand(at)web(dot)de> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Two server instances on one server |
Date: | 2024-04-10 20:38:50 |
Message-ID: | 644908bed5bd78e5d0d514a57f894a1451daec2e.camel@web.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2024-04-10 20:41:58 | Re: Two server instances on one server |
Previous Message | Tom Lane | 2024-04-10 20:31:34 | Re: Failure of postgres_fdw because of TimeZone setting |