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 1rZc3W-005Tfv-O7 for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Feb 2024 19:33:31 +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 1rZc3V-00CZ2U-TB for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Feb 2024 19:33:29 +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 1rZc3V-00CZ1t-Es for pgsql-hackers@lists.postgresql.org; Mon, 12 Feb 2024 19:33:29 +0000 Received: from mail-pl1-x636.google.com ([2607:f8b0:4864:20::636]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rZc3S-006PqI-Qb for pgsql-hackers@lists.postgresql.org; Mon, 12 Feb 2024 19:33:28 +0000 Received: by mail-pl1-x636.google.com with SMTP id d9443c01a7336-1d918008b99so24632425ad.3 for ; Mon, 12 Feb 2024 11:33:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1707766406; x=1708371206; darn=lists.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=IPo5Yne5gqUDo+UcTSXsmDQP2NyRlE0Mmg4Zdxkie9I=; b=UH9LMRFxXLUIOOwvLLudRHWk1+ToL/UiFFHjYYHO8vtv9hR3WfrbH4J53+O4vw+kPq UN62dp5xpZ6jztGyuw62N3AZY81qt4m71hRbDz/j2MsW6QrAJHtM0SIjfek6TKZtAEpP vW0jHfGHjAvEcQjU32T5LkwqnBvqbpd7iWfKcpKWfymvwXNwP+ZOE6UPRhi/+xc9lt/b NwJBDFgkyZbvEN1+CgQfJ4X662/4RVfF+Bz8RJF4xG+uFAgzbSgE1S+fFWfonA6oY9+P JzzlYcRD8q7zlT+e29G/2lwz+ti66zIhaXi+8LTQxDWQHoAuLEQ8n5K7CbKzCOwEqvaD ++xQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1707766406; x=1708371206; 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=IPo5Yne5gqUDo+UcTSXsmDQP2NyRlE0Mmg4Zdxkie9I=; b=n3CFG0ETkFi8XeRjPv87ogols9HMdUmFnLtwxi3YdszpGhf6PGGN2dCW+VPdaEaoYI UHhelrYlDhoDvXY4SKpQv1zDxWarzYmqf3ViwhA/NwbkK915ymfMvtQqBwBTdbEPaEYY 83ERgoPfriv/O6D8GOXKcg10bSt8CEldp2yHOBbFcyWASN9zN9nmU59ZXbKvq62texLQ 2xnEd9jfXl9Weg4vKyPNmuEUHGfIc6SKMI1gwpUJu+CYQz2v8euJf17bXRsBpZvxit9w K3XdAk3YLgttt0u5WuT1nJPU0D9YT/BCJzF25IfAShd2YYnr5inksxitvGPOn0ff0eTB +z/Q== X-Forwarded-Encrypted: i=1; AJvYcCVYW/zmv9BXj+7yrlB4/UA53hP+sp1ADH4CyxMGEp9q8vLTsh3xjRNzqdEf0bUnybyi8oNFlmig0EKhs7ApZdlChW61v7YDtjoU/sdQKcTIGJbm X-Gm-Message-State: AOJu0Yzu+j7G4I17C92198GIZJV2igMoRmFhj/MfGtSsEoqIZjNLeFZX 5XLrznuixpf4vlaUG21deX12hHVW1B11ObMebQ6XgT1aNfE6ozNQohwwrtGbEA== X-Google-Smtp-Source: AGHT+IFCOGvsLR7yach1u/p2LjkLsNFZtlVQjWDGQTPqsT7Nq5aXixTlrj66+T5x8e2Zpn/+6nnn0A== X-Received: by 2002:a17:902:eb86:b0:1da:2a50:cc09 with SMTP id q6-20020a170902eb8600b001da2a50cc09mr4641837plg.12.1707766405745; Mon, 12 Feb 2024 11:33:25 -0800 (PST) X-Forwarded-Encrypted: i=1; AJvYcCX7er/mtv7C/EIiyLlpBWFF2C2VA4/ayHj5mwJ1W9t3rzvxKd21R5pyIuU+9j9K9r1V5lFF84x4o3dIulaOjOqQ8Yikkm/VTPFvXGHsgl7OEfxUgydqARPVyQLMt2aw9kJONqgRABFG1TXChpo5v3G+H+SZw96Ic0nK95dTJEKO6uEv1QfDHqGLPI7QnQtCky36CfT5n0wmCozLyTCSCL7ckfA9IqpCRW5aX0iJrYIh1FPGqNdrK0PzTEBUT2NUgpQLL85lb6xe+6fPmRY= Received: from [172.18.10.46] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id m3-20020a170902f20300b001da2938f993sm705389plc.92.2024.02.12.11.33.24 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 12 Feb 2024 11:33:25 -0800 (PST) Message-ID: Subject: Re: Improve WALRead() to suck data directly from WAL buffers when possible From: Jeff Davis To: Bharath Rupireddy , Alvaro Herrera Cc: Andres Freund , Dilip Kumar , Kyotaro Horiguchi , pgsql-hackers@lists.postgresql.org, Nathan Bossart , Masahiko Sawada Date: Mon, 12 Feb 2024 11:33:24 -0800 In-Reply-To: References: <202401301731.o3cthlcry4ve@alvherre.pgsql> 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 Wed, 2024-01-31 at 14:30 +0530, Bharath Rupireddy wrote: > Please see the attached v22 patch set. Committed 0001. For 0002 & 0003, I'd like more clarity on how they will actually be used by an extension. For 0004, we need to resolve why callers are using XLOG_BLCKSZ and we can fix that independently, as discussed here: https://www.postgresql.org/message-id/CALj2ACV=3DC1GZT9XQRm4iN1NV1T=3DhLA_h= sGWNx2Y5-G+mSwdhNg@mail.gmail.com Regards, Jeff Davis