From: | Andreas Wagner <thewand(at)web(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Two server instances on one server |
Date: | 2024-04-11 07:07:08 |
Message-ID: | 975f53af426aed43374abbc494ac82517119876d.camel@web.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Am Mittwoch, dem 10.04.2024 um 16:41 -0400 schrieb Tom Lane:
> 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?
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
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick FICHE | 2024-04-11 07:41:56 | RE: (When) can a single SQL statement return multiple result sets? |
Previous Message | Thomas Kellerer | 2024-04-11 05:25:59 | Re: (When) can a single SQL statement return multiple result sets? |