From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andreas Wagner <thewand@web.de>
cc: pgsql-general@lists.postgresql.org
Subject: Re: Two server instances on one server
In-reply-to: <644908bed5bd78e5d0d514a57f894a1451daec2e.camel@web.de>
References: <644908bed5bd78e5d0d514a57f894a1451daec2e.camel@web.de>
Comments: In-reply-to Andreas Wagner <thewand@web.de>
	message dated "Wed, 10 Apr 2024 22:38:50 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <4180219.1712781718.1@sss.pgh.pa.us>
Date: Wed, 10 Apr 2024 16:41:58 -0400
Message-ID: <4180220.1712781718@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/4180220.1712781718%40sss.pgh.pa.us>
Precedence: bulk

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