Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rzFnt-002klw-OL for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Apr 2024 13:03:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rzFns-008UBG-2i for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Apr 2024 13:03:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rzFnr-008UB8-Ji for pgsql-hackers@lists.postgresql.org; Tue, 23 Apr 2024 13:03:19 +0000 Received: from forwardcorp1b.mail.yandex.net ([2a02:6b8:c02:900:1:45:d181:df01]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rzFnl-002WT5-37 for pgsql-hackers@lists.postgresql.org; Tue, 23 Apr 2024 13:03:18 +0000 Received: from mail-nwsmtp-smtp-corp-main-26.myt.yp-c.yandex.net (mail-nwsmtp-smtp-corp-main-26.myt.yp-c.yandex.net [IPv6:2a02:6b8:c12:290f:0:640:2b99:0]) by forwardcorp1b.mail.yandex.net (Yandex) with ESMTPS id F32D460A85; Tue, 23 Apr 2024 16:03:10 +0300 (MSK) Received: from smtpclient.apple (unknown [2a02:6b8:b081:6556::1:3]) by mail-nwsmtp-smtp-corp-main-26.myt.yp-c.yandex.net (smtpcorp/Yandex) with ESMTPSA id 83KmM22iDiE0-LKf0WyDI; Tue, 23 Apr 2024 16:03:09 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex-team.ru; s=default; t=1713877389; bh=wB/eX293vG1EHLZjexK8c6w54FGh/WmdXwh0N7efHaw=; h=Message-Id:To:Date:References:Cc:In-Reply-To:From:Subject; b=Ika2EP6VFVpOPeuJpqTznw+iOlAftD1ZjFGgzz9FKn6PkFA5Nf4I7a0Lo9KaK60R9 dBvr0PUO98ZIgrudM0SgfySOLUb3vy5PqP+dl0h+cCxGcITGKZcpvrwoPkJKY45tmm KSj7sOj4wT/O9/SNogYoDXhEzlBcLixf3AkrBLbU= Authentication-Results: mail-nwsmtp-smtp-corp-main-26.myt.yp-c.yandex.net; dkim=pass header.i=@yandex-team.ru Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.8\)) Subject: Re: POC: make mxidoff 64 bits From: "Andrey M. Borodin" In-Reply-To: Date: Tue, 23 Apr 2024 16:02:56 +0300 Cc: Postgres hackers Content-Transfer-Encoding: quoted-printable Message-Id: <523CEE07-5151-412A-A7EB-A4C722EE14F7@yandex-team.ru> References: To: Maxim Orlov X-Mailer: Apple Mail (2.3696.120.41.1.8) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 23 Apr 2024, at 11:23, Maxim Orlov wrote: >=20 > Make multixact offsets 64 bit. - ereport(ERROR, - = (errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED), - errmsg("multixact \"members\" limit = exceeded"), Personally, I'd be happy with this! We had some incidents where the only = mitigation was vacuum settings tweaking. BTW as a side note... I see lot's of casts to (unsigned long long), = can't we just cast to MultiXactOffset? Best regards, Andrey Borodin.=