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 1rnNlU-00Czqz-QD for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Mar 2024 19:07:49 +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 1rnNlT-00FfxY-2Z for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Mar 2024 19:07:47 +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 1rnNlS-00FfxQ-Pc for pgsql-hackers@lists.postgresql.org; Thu, 21 Mar 2024 19:07:47 +0000 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rnNlL-005ilz-AZ for pgsql-hackers@postgresql.org; Thu, 21 Mar 2024 19:07:45 +0000 Received: by mail-pl1-x62d.google.com with SMTP id d9443c01a7336-1e01c38f98cso8863605ad.3 for ; Thu, 21 Mar 2024 12:07:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1711048059; x=1711652859; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=Y99/hFxrBLZSunZsQ6oS61Q4rxNCH+yz5cyAe4PoMBk=; b=cdWKh/JRfqwiSuI6U53JXSUgxDc8yruY8xXie2BSd07Vurhs0DFTlvATpd9bDos5Hz INWbi8sNkghvq8iaxEklNKsItsZyJFkdOuVIMr72f7T9nPOfWsdgB3J+ErP6UzK56fV5 GBxBMMIB422gHhEOwmrS91sh9aX8CqhHkIbXJFbYi+CjFOb/yNCgJUPsR1fkJb1G55P9 FNorD1rkXuxqi5BwqBWuqejRL4vkwh6oC60MHYcVmsCx5CF/ID5xtjthfhFTeHCNQfaG +3xg7yKnyTyVm56+8Lojw9Jge3YG+zds6EcwjBV9xEfht8u48WAkcr4EP78m4IL2ZDww 13RQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1711048059; x=1711652859; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Y99/hFxrBLZSunZsQ6oS61Q4rxNCH+yz5cyAe4PoMBk=; b=kEO8Z3ueuL5TAu/6OPJp+CbYWjRm+LN8csODm2f4NdmRZJFxsbeX7zKXmFlIBJRj9R c6IJFrqyaK/eN6dGq5zhTBQF3WJBrHq0L9QaJoU9toK7SZsihjrmKlIGF87N5JmvfFAD lYC+Jg38YM8onBR9TDuabzFH4oqyU2U89IDgS0bT5YyXyC/vuG9976tfL+o6F3hcsQ5V FDS7wuECpGQjceLVnI0lBscX+MwSD6ICDa1gxlb3keHwI1WLngsDsbZ8RSEH+SUAznvy 4twoZCqXGfszg/8Yy9svWl6cOr/lZNUDCEJqUOP9ekqfVxoJCbkZARgNuTd5c08ybM/r 6hZg== X-Forwarded-Encrypted: i=1; AJvYcCUGJS/pzdRejoiLUd2JnXTFFgqBZE5d4BGOODtjWzIt2SmOcfimWWF90GQ7qtxhMungBJPDVwXXdesXl5IXA6+9HSYkosg2DLIzVswa X-Gm-Message-State: AOJu0YwGVWdS5Cs50UWLLh9uIvGye07NHTsRLI0Q2bEVrQUyTX1EmUmo tyWsHoV2SCuWUu15SWML22xiZ2iUHuHnpxW6jWGlhfxQdVkSkBTfZ9opqyd/K5AKDOG4MFADPv4 = X-Google-Smtp-Source: AGHT+IFgjCNzxkdfcAaqN7NAjIKIiq+uoeYFG2xbTpIK4YwNFVq6TfaVlioA9C6LtKg2Tuyg1xx8qw== X-Received: by 2002:a17:903:1208:b0:1e0:188a:5ae1 with SMTP id l8-20020a170903120800b001e0188a5ae1mr400518plh.10.1711048059539; Thu, 21 Mar 2024 12:07:39 -0700 (PDT) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id r1-20020a1709028bc100b001dc96cb0358sm176105plo.206.2024.03.21.12.07.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 21 Mar 2024 12:07:39 -0700 (PDT) Message-ID: Subject: Re: Comments on Custom RMGRs From: Jeff Davis To: Danil Anisimow Cc: Andres Freund , PostgreSQL Hackers Date: Thu, 21 Mar 2024 12:07:38 -0700 In-Reply-To: References: <20220512034010.4oqa76pasrulkw32@alap3.anarazel.de> <20220512234207.pwwp6q33f72byet2@alap3.anarazel.de> <0892cd00635c8bcd458de6d43d31cf61953da1b2.camel@j-davis.com> <727b0f3b48aec2a4f968bf11c6fa8ca6382b6cca.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2024-03-21 at 19:47 +0700, Danil Anisimow wrote: > The proposed patch is not a complete solution for pgss and may not > work correctly with replication. Also, what is the desired behavior during replication? Should queries on the primary be represented in pgss on the replica? If the answer is yes, should they be differentiated somehow so that you can know where the slow queries are running? Regards, Jeff Davis