Message-ID: <975f53af426aed43374abbc494ac82517119876d.camel@web.de>
Subject: Re: Two server instances on one server
From: Andreas Wagner <thewand@web.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
Date: Thu, 11 Apr 2024 09:07:08 +0200
In-Reply-To: <4180220.1712781718@sss.pgh.pa.us>
References: <644908bed5bd78e5d0d514a57f894a1451daec2e.camel@web.de>
	 <4180220.1712781718@sss.pgh.pa.us>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.0 
MIME-Version: 1.0
UI-OutboundReport: notjunk:1;M01:P0:0+otOhH5g2A=;gWNNuszG4lIPCmJRNN+uWyGZQjm
 oXXU7tmsk6NE78BLYu6I031GXCyKt0v/6mSkgQo5UCnAdMvzUps62XfJfKu7GZLr3dAeEsM11
 lAzQ3cj56HcU4Js/GVifH6r8jxCMoQ2un4sCUhQ5L58vXsn4Jmoj4YMKeURnaN2wr0gUVERAn
 rT+jqkgHfVtQpmRUX7c7U/atzPkarUcQXGzTUX5HmkKGavi+UWChAiiBrnokxu4GLWNJQUM9U
 guKg7mwxbouuP7eLHENbkwegQR6frNo0fTQylY/WA4AOiDUtc27+i591zu7FZf5BA47BvBLT/
 UwK5xrystHMsVHnOrqaOiOfhhg1f4zfq1L0BZkCq/EglnMh35+Axjfh/8KplmEJWwCa51/BE2
 H79ML9zFV2gxea4n/aq0rc1C7QR4EpVY5HcRmL5IBRscgR6YhEHlSy9AKAF2oH3ru6KfGdgDv
 nJrvGIjoD1AAMFeqN0GSGSpAuU9uhQlxW5s+kyBXdIskIPuHHpQudpUN0zk5Xd+m62Vr2tYEN
 SAEh1gsrOJQy7FFQAhP7WU5jFkxbB6vn30M8ORQ9oamNzbf4ysYZvPaZA3TcBnhMhmR8LA3FB
 eM5f1Gqt7KYb1Jj3HqlAIri2im/xj0iN4rlw9Ac+qU3iHVdz5tVqrfLTg4zA29APCnwVe7g7E
 hGQcchvQyE59qWuMazySahMMk5ZhPG9z8CW1nmHPnokfIGlWSs1qdYxl+DI36wzZsgcq4YkFv
 j0b+xXIQMWTv5lLKm6t1TuIpBnQ/oC/yB+8zMhlCLuMDZJQDS1dxid58l3cjkQAdjvbA+K5C/
 40SmcFmrnrVPtC315UZjxq4pNwUVXlwXHTcOohZJJ5zOs=
Archived-At: <https://www.postgresql.org/message-id/975f53af426aed43374abbc494ac82517119876d.camel%40web.de>
Precedence: bulk

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.
>=20
> Seems straightforward enough to me, as long as you put the instances
> onto distinct port numbers.=C2=A0 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