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 1tJ6uz-000yDL-6i for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Dec 2024 08:09:01 +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 1tJ6uv-0055cZ-PT for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Dec 2024 08:08:59 +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 1tJ6uv-0055cR-F8 for pgsql-hackers@lists.postgresql.org; Thu, 05 Dec 2024 08:08:58 +0000 Received: from mail-pj1-x102f.google.com ([2607:f8b0:4864:20::102f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tJ6ut-0019VZ-O6 for pgsql-hackers@lists.postgresql.org; Thu, 05 Dec 2024 08:08:57 +0000 Received: by mail-pj1-x102f.google.com with SMTP id 98e67ed59e1d1-2ee989553c1so565999a91.3 for ; Thu, 05 Dec 2024 00:08:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=timescale.com; s=google; t=1733386134; x=1733990934; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=ezmkYi8CyPGb4C1aUUFDF0H2UUtMwD4DfLVG6MXnVFo=; b=T8mWe457QgklakaGwCKgC0w5EEJY7vxJfUi3YUsCPFpNdcJzgGIOrygeg+Z9nWP5bJ zBuGSSIirrYCYBNow+F+zXlEEWVcXbVtU+EmpkxH1ANRrgSvWAEZ0dRzASqctmbQwkPl qOTtyN35Fds+WdU0mlGTLgDt4sL9FfUYh3DPFls3mngPAZYkz1bTarVxOviBMMz3kkoA YAXhPnK0qrRo80EFOuQnk2KhfE3jz7b25iyJx9kBTKyrDdfjxhWMHJ4ds1kEk3MYHq3Y tbPoWBIZdi4CvUsB+M23XtkkvMYpJthpJD7xIs9a7al/JuT+4dat+HkOkUXTUDfPluMD Rgeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1733386134; x=1733990934; h=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=ezmkYi8CyPGb4C1aUUFDF0H2UUtMwD4DfLVG6MXnVFo=; b=jHC4HcA0X14U3pfhMuC+0kNZqAAtE0u15MPCJnIa7I/sqaq24hkA4aSDUPB8VOu3uz cpQrcvqSIPAtLIxdu2tBCC+pdiEf21rqcouJ8Z/zpMLf52Wq5hhwHALVP42Viq3VinPL OtniRv3D/QVWYGJjXicYH9zZoAaiJ5rV7tpXlqYdlvIvMrlU3I/QWS+HFuHUyDjNKkJX M0I/BX7iktpx+OyiNwGGsZ9nmFkRV7W3CCoR5Ij1JaZDGcV+sLQjuNnKM+O78VAk0IfQ WZ8hB7U+144E3QM2qIvBUnUVKqYvx7PXMxajrmRPalrtWvOBar77+FTC0w9zbf1cVaAY kEzA== X-Gm-Message-State: AOJu0YyX5cvxWNsLYNTow6bH9OaY03vqMapAI7xOmqP8ElMkeYJNbMQN 4VKfq50Kf+Cb9aiTE8wCVVFveFhPKjp8nQqfgX24JI7P3wDFGVDhjw2+DDTkxApuWZkUxdAbzv7 0s7Vyy43Z8pbAjfZ6/T0J4UeEgB+JWJYCLkU9sm3sWlHxJ25V0YvEyw== X-Gm-Gg: ASbGncu2/VNTO4N0qV46xsJJiY9wSW/+FUmDu1+Z4rkggIEbNCb1GTP2DaYljIHtMxA cL9yu5yv2kmY+TJrYjAt6lgD209iqIg== X-Google-Smtp-Source: AGHT+IENL3IG7hae4xl68SpS7+SknCtEy3fa9BmLXFZDTwxv2tMLQD5zctXpaoyQmEVTi7Vjevt5AaXm6PWhcBC6p8A= X-Received: by 2002:a17:90b:3841:b0:2ee:d18c:7d84 with SMTP id 98e67ed59e1d1-2ef012116damr14764693a91.20.1733386133676; Thu, 05 Dec 2024 00:08:53 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Aleksander Alekseev Date: Thu, 5 Dec 2024 11:08:42 +0300 Message-ID: Subject: Re: [PATCH] Refactor SLRU to always use long file names To: PostgreSQL Hackers Cc: Michael Paquier Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, > I guess we are going to need either a `pg_writecontoldata` tool or > `pg_controldata -w` flag. I wonder which option you find more > attractive, or maybe you have better ideas? For the record, Michael and I had a brief discussion about this offlist and decided to abandon the idea of adding TAP tests, relying only on buildfarm. Also I will check if we have a clear error message in case when a user forgot to run pg_upgrade and running new slru.c with old filenames. If the user doesn't get such an error message I will see if it's possible to add it somewhere in slru.c without introducing much performance overhead. Also I'm going to submit precise steps to test this migration manually for the reviewers convenience. -- Best regards, Aleksander Alekseev