pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedTwo server instances on one server
3+ messages / 2 participants
[nested] [flat]
* Two server instances on one server
@ 2024-04-10 20:38 Andreas Wagner <thewand@web.de>
0 siblings, 1 reply; 3+ messages in thread
From: Andreas Wagner @ 2024-04-10 20:38 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Two server instances on one server
@ 2024-04-10 20:41 Tom Lane <tgl@sss.pgh.pa.us>
parent: Andreas Wagner <thewand@web.de>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2024-04-10 20:41 UTC (permalink / raw)
To: Andreas Wagner <thewand@web.de>; +Cc: pgsql-general@lists.postgresql.org
Andreas Wagner <thewand@web.de> writes:
> 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.
Seems straightforward enough to me, as long as you put the instances
onto distinct port numbers. Are you encountering problems?
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Two server instances on one server
@ 2024-04-11 07:07 Andreas Wagner <thewand@web.de>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Andreas Wagner @ 2024-04-11 07:07 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-general@lists.postgresql.org
Am Mittwoch, dem 10.04.2024 um 16:41 -0400 schrieb Tom Lane:
> Andreas Wagner <thewand@web.de> writes:
> > 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.
>
> Seems straightforward enough to me, as long as you put the instances
> onto distinct port numbers. Are you encountering problems?
I don't see a way, yet, to put one half of the partitions on on
instance ond the other half to the other, automatically. Replication
seems to be a 1:1 copy and partitioning seems to stick to one instance.
Regards,
Andreas Wagner
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-04-11 07:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-04-10 20:38 Two server instances on one server Andreas Wagner <thewand@web.de>
2024-04-10 20:41 ` Tom Lane <tgl@sss.pgh.pa.us>
2024-04-11 07:07 ` Andreas Wagner <thewand@web.de>
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