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 1snWUR-004B6B-9e for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Sep 2024 04:59:04 +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 1snWUQ-0065d4-O6 for pgsql-hackers@arkaria.postgresql.org; Mon, 09 Sep 2024 04:59:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1snWUQ-0065cv-Ds for pgsql-hackers@lists.postgresql.org; Mon, 09 Sep 2024 04:59:02 +0000 Received: from mail-wr1-x431.google.com ([2a00:1450:4864:20::431]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1snWUJ-000F5f-Vo for pgsql-hackers@lists.postgresql.org; Mon, 09 Sep 2024 04:59:01 +0000 Received: by mail-wr1-x431.google.com with SMTP id ffacd0b85a97d-374bfc395a5so2202306f8f.0 for ; Sun, 08 Sep 2024 21:58:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725857935; x=1726462735; 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=oVca8HQvDkDzC9pHCCbNd7rbsrVY+ouPMAlg+Oc7zPU=; b=Pewf6qoi5jI4gj3cTEH0jx/PrwXcYjS22mjBVHf1nJ82Qiywi4oNbE2CpnwT7HzNsb IlAukP4FlU4ejeT/u2O9EUSgiPbCxHO1wbXw2FXs8QwxVCAB8L5xKnpupbqzpJwXVxtg S2QblTXrf/KBj0za84W5VKanYzzKNzBSBdxeqsFsPSbP7NhLNZ0+BFALZ8sgUMRvMInH sT1Wp7V+S/UAZaq7Z3gJQKr4LOa4A+NWAgBqkPuPC14F0XqK9bCHSIIXtxwstPl/NWhQ hbyFmZFmcRqvUj/Vb17VuPHbB3VdyvcyKj3ysiV+1VC2SUcbjJ2CFr0uctJyQLNQkjb9 rUkA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725857935; x=1726462735; 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=oVca8HQvDkDzC9pHCCbNd7rbsrVY+ouPMAlg+Oc7zPU=; b=A31Ze3O6LM5hZWugtm9lWcKj4BHHY64MD6KXzldp8GKyZcnf4xWdBnGxjB31Ug0VIi eqhnXD9qiaInz2HiTQIox0G3Ymn+ylf5qXO99lNUi8MgKD6hngxATn/YsmGZ4eTJx6j8 D55c1hJakkZM5WLmFwKs7qekkUhZyw+WcGb0VsTmKykOLaxyg9mB2ICFULzCe3ERuQNg lMsax1SEkKqByNe6pTYL+FUMo/0LrXuadp27QQGJa7+rfgCN2GhroWo9ArEKpRulzIRr ABvnlloQimdHbA7YCNAP/XzeltMCxmyDdQkAOfIFaWOoeKA122DkEWiVdZy6WKgW+C7N NKww== X-Forwarded-Encrypted: i=1; AJvYcCVBN7jwDuybdzJl9fePUcH90ZsoPRo0lbhXRhXdVnQPC0E/F0VDbdz2JKQuv760juDROulxbMXYOW9moT60@lists.postgresql.org X-Gm-Message-State: AOJu0YzGmFO5jB6xnmbdjE7dm2GWUabmOldqLExGifL1f6st4J0HfSGq +VADsus2J6Iw/8Nmb8xduOwViM7bGxFeZPF2hRmNAs5NnWyMpetu+pXIx3EFb1m0NK209wmC28o 7NfogJeSlv+XjuepNPn9N1q6rf3k= X-Google-Smtp-Source: AGHT+IG0g6uFwXsxCNpMvGvdl1JIluPSbtQPpM2Joe/GYx1+N7CE5itutIVCl2Ytk2bMlkZ0meLp5XM5+y4qHRLVNdw= X-Received: by 2002:a5d:4447:0:b0:374:c4c2:5ad5 with SMTP id ffacd0b85a97d-37888847f85mr6258742f8f.27.1725857933878; Sun, 08 Sep 2024 21:58:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: shveta malik Date: Mon, 9 Sep 2024 10:28:42 +0530 Message-ID: Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation To: Bharath Rupireddy Cc: Amit Kapila , Peter Smith , Ajin Cherian , Bertrand Drouvot , Masahiko Sawada , Nathan Bossart , PostgreSQL Hackers 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 9, 2024 at 10:26=E2=80=AFAM Bharath Rupireddy wrote: > > Hi, > > On Mon, Sep 9, 2024 at 9:17=E2=80=AFAM shveta malik wrote: > > > > > We should not allow the invalid replication slot to be altered > > > irrespective of the reason unless there is any benefit. > > > > Okay, then I think we need to change the existing behaviour of the > > other invalidation causes which still allow alter-slot. > > +1. Perhaps, track it in a separate thread? I think so. It does not come under the scope of this thread. thanks Shveta