Re: Two server instances on one server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Wagner <thewand(at)web(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Two server instances on one server
Date: 2024-04-10 20:41:58
Message-ID: 4180220.1712781718@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas Wagner <thewand(at)web(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Behrens 2024-04-10 21:22:47 (When) can a single SQL statement return multiple result sets?
Previous Message Andreas Wagner 2024-04-10 20:38:50 Two server instances on one server