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 1sqoXv-00D2Fz-1K for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Sep 2024 06:52:16 +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 1sqoXs-004uJV-RR for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Sep 2024 06:52:12 +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 1sqoXs-004uJN-G9 for pgsql-hackers@lists.postgresql.org; Wed, 18 Sep 2024 06:52:12 +0000 Received: from mail-wm1-x32f.google.com ([2a00:1450:4864:20::32f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sqoXo-001m7W-V7 for pgsql-hackers@lists.postgresql.org; Wed, 18 Sep 2024 06:52:11 +0000 Received: by mail-wm1-x32f.google.com with SMTP id 5b1f17b1804b1-42cba6cdf32so53761945e9.1 for ; Tue, 17 Sep 2024 23:52:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726642329; x=1727247129; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=exBHUuBplzv/xhLgVEvjB9T/6JRY6ppzRtxUgKcvd6o=; b=iX+RBGsDFRdPGjTXLlhjGfe8GDodTG9Z4uTq+BAQcQdGH0/U0jM7Wfutacn1i95KGH OTfxyIGbKuZ9olvFID9r4X1uwbfA3WHtZpYSKWp3z/2Sk2zpfzNd2NUqMjYZRApbRtIv NiwWyGP1lW6MtGqySH7r6PjYhgWs7o818NmT98FeZ36cl1CIHO1MIp7KDSJ4qEIFFYBT SSV3P5JeTzr06bRB7tIXVqF83otxXzmc24xd4Pddrm80N5WQczr5KhEOQVJXKjA/ekUs gDTZUZcqY3XV+YUeVZZXcPYyyV+ZXSouumbqS/QS0Lvc6i9jHVMciYqpb/uEuZ4Zmasa wpig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726642329; x=1727247129; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=exBHUuBplzv/xhLgVEvjB9T/6JRY6ppzRtxUgKcvd6o=; b=ZCgg6orbmssUmC/+6bkRC/o6Emm6v7a/4ICgD/kP3XnmITb44jy+RNRnSKX9Msuhtn fVwfIkc4ERPg6atVPwY8TyMh8UlGcU8LRLMCICxzgH9GZFmT7Ao8ffcHmvNQEI835xCU YyfVgz1aLrfE2Jct0WjdyZksqUxsGXxD4rjyqFZbIqZBwZe5nS0tb75Q/yEqJKiOaWeK d/1Q2I0QhELhWE4yJD9lKnC/hhQoxuvTHwbZb4o5XZxXfo4ErZKHU1bpM1kb4dOfnbQL P4DSWypftFGRwojlpNBqdYzsrMl0WRzqDJRNnn+YyMogkvoNcBgYkogrq3nOgunovD9F a+pw== X-Forwarded-Encrypted: i=1; AJvYcCVdjo4EF7VBY5ytA2YJURGDQErfnHUF78L6nzv2dasVKO1FTo2z7R54wvtoPnGjTckcj+U+8QI4aByGOt2H@lists.postgresql.org X-Gm-Message-State: AOJu0YwtkGva98DR8zvwosSh93cik38/x4NZY0uc7RUXTIuYxzzki3Cl 92szqfr3NhUi93Sm4gWDUv8z0tCrnr6QI7lQSmYuEjKpKQdTNqPVdlBbmIXxbIhrjNYzmscdjOT 01ckvCY/snO+i4L9i5SNK/QeCotk= X-Google-Smtp-Source: AGHT+IHWEaY1u2JsTUvPaXifmQ6C7NpOu/J9+EH724DJIGU8CgCjClDXWrsh5w3klv4Oszqs+o7RvZdrLKg0FqrFgr0= X-Received: by 2002:a05:600c:154d:b0:428:e866:3933 with SMTP id 5b1f17b1804b1-42cdb57c45fmr163862905e9.22.1726642328660; Tue, 17 Sep 2024 23:52:08 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: shveta malik Date: Wed, 18 Sep 2024 12:21:56 +0530 Message-ID: Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation To: Bharath Rupireddy Cc: Peter Smith , Amit Kapila , Ajin Cherian , Bertrand Drouvot , Masahiko Sawada , Nathan Bossart , PostgreSQL Hackers , shveta malik Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Sep 16, 2024 at 3:31=E2=80=AFPM Bharath Rupireddy wrote: > > Hi, > > > Please find the attached v46 patch having changes for the above review > comments and your test review comments and Shveta's review comments. > Thanks for addressing comments. Is there a reason that we don't support this invalidation on hot standby for non-synced slots? Shouldn't we support this time-based invalidation there too just like other invalidations? thanks Shveta