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.96) (envelope-from ) id 1wEBQ8-003lDf-2Q for pgsql-docs@arkaria.postgresql.org; Sat, 18 Apr 2026 19:33:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEBQ7-00DgQz-1n for pgsql-docs@arkaria.postgresql.org; Sat, 18 Apr 2026 19:33:35 +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.96) (envelope-from ) id 1wE5uX-00D0Vj-2r for pgsql-docs@lists.postgresql.org; Sat, 18 Apr 2026 13:40:37 +0000 Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wE5uV-00000001d2N-3phD for pgsql-docs@lists.postgresql.org; Sat, 18 Apr 2026 13:40:37 +0000 Received: by mail-wr1-x42b.google.com with SMTP id ffacd0b85a97d-43d7e23defbso993106f8f.0 for ; Sat, 18 Apr 2026 06:40:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776519634; x=1777124434; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=g/KBSi+aGBxWPaRa+Ef/hC4aTIeohHU51b2SVD9Rt2o=; b=A8e0idSVuYAm41UANZ09vy8OtO65vbpRL5YaJtsVchRxPGlwLF2um/fOvkTf+vv+AU zbTXvb2VWgD6wy3WXDvZRdbJ+00sh6eN4+Gv5Xv0ndynExkghbKu6KAtTadLtRQvgldC m2n/UDz9U+38NHOFO1vT/v/xTeL4hVBom5mvKEeaHNqJb7IAa9w0olmtj9gt3qBV474B Q0F0fmsSpYMpWvev72izibQGyY24f4m6a4ehy33TlmUehYnvgT/O8+KmtBug258S7+Sx L9nOm7mS3F8Ruujp2DRCCKy569yzarLEhZH5yj+NY9tqstJAL9ppGtNex5l70Zrex4U5 hRHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776519634; x=1777124434; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-gg:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=g/KBSi+aGBxWPaRa+Ef/hC4aTIeohHU51b2SVD9Rt2o=; b=HbgiJLLzPkcTouSQQELHo2QgJjQEmgUdysKmMBGJJe5tua9YUY2nnffK1AXuwDBLEm d6FrJyhrVE6xH+5joVx2CsiO3MUsJn1GxE7lEtFi+YCq6lm1xPULadCCSWXMjqqBgkdq Rt+WdhuwA1lo5RdBBe8pGU6vIkufM8wzoQ0FR1SqRfSA545GQLCEY8FrSP3P2NsWz9iL 69ij07Aw7qRvnP914jD7Yfx2R3IBOn8alSlaoqdYp9iXIyueZG1q0ftAKhuyYc1eIM93 nGXMMBB+L/b71bcPD13VC8o3toJcxxQy5rCYvYnjcmqVB6B9z1yKmV7g8uOVIKWm/d4i 6Xsg== X-Gm-Message-State: AOJu0YxlLrqxJOttvCQE49eoejFEecoLqyYrZ1fXBeuD1LfCxcPM3XNT zSoVeo8zCZkF8F2gzl09kuLYA8mq38YkAShPkYVOM+vfGIQczNpRBENgZppk+7GU X-Gm-Gg: AeBDiesonDTrXCBNc7EREBGmMhHJuxpUKv37/0GmVFaH95TmMHS6t7zIK9Sbl0U5poY ElWIslZPm0caP5D85NuQtXdCyOaXz0HglY03GZXJ0eN2DOVTl1VOytC8RApI8MslpuIn0NoiUUW Kybw/GMjWNdsmxZ5K4NUdSQukgW3t4bX1ikxuPxhmjgWvxTY5Zcw70YTeE8FMzdIj+wcF/LxdWp Vix0IyXwQoNqw7ujLCtyIiBdjeV3yuqUcLRCKriPB/wTVe2NwKdkKS08LfbuWgs0m+zC7jVA0Iq bXdbt8c8bQUL6Z5sjgg2Y0Ey02+qeirg6WqkGnkwXiPEYrd4WMyMuJhT34OLCUV3NOVCgorBrZm PxJciUhtJcR77WPMtPTOiEhUtsAGpaaAgNKQH0IdyZ2+qYR6MADsacoaj21uLoG66x+95vC4o+g NApUIQU+yUo/btFZNGkWcpRFT4gsqR8WP5jVEsONtW3Dev2kbTCgY1r31qKQKSsjqRVbsb9JC2Q X1Kgi385neZCaQ9/JTOjZ69mwQYKghtOS1A X-Received: by 2002:a05:6000:144d:b0:43d:60e:6aff with SMTP id ffacd0b85a97d-43fe3dc63ebmr9694042f8f.15.1776519634319; Sat, 18 Apr 2026 06:40:34 -0700 (PDT) Received: from smtpclient.apple (251.red-79-146-197.dynamicip.rima-tde.net. [79.146.197.251]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-43fe4cb1249sm11448139f8f.5.2026.04.18.06.40.33 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 18 Apr 2026 06:40:34 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-FF602487-752C-49B8-BAA0-B59824AB37B6 Content-Transfer-Encoding: 7bit From: =?utf-8?Q?V=C3=ADctor_Herraiz_Posada?= Mime-Version: 1.0 (1.0) Subject: Re: Temporary tables and Write-Ahead Log Date: Sat, 18 Apr 2026 15:40:22 +0200 Message-Id: <5B6C7843-175D-44F5-8B7C-B823EF6F8BB0@gmail.com> References: Cc: pgsql-docs@lists.postgresql.org In-Reply-To: To: "David G. Johnston" X-Mailer: iPhone Mail (23E254) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-FF602487-752C-49B8-BAA0-B59824AB37B6 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Thank you David. I would be g= reat to have that in the documents. I saw several =E2=80=9Copinions=E2=80=9D= across internet.

El 18 a= br 2026, a las 9:01, David G. Johnston <david.g.johnston@gmail.com> es= cribi=C3=B3:

=EF=BB=BFOn Friday, April 17, 2026, V=C3=ADctor Herraiz Posada <victor.herraiz@gmail.com> wro= te:
In create table documentation is not cl= ear if temporary tables use the write-ahead log. Could you please add a sent= ence about that like in the unlogged tables?

The word =E2=80=9Ctemporary=E2=80=9D is com= municating the entire first paragraph of what we spell out in unlogged.

However, maybe I=E2=80=99d add to the end:
=E2=80=9CAside from the above, a temporary table behaves much l= ike an unlogged table - though a partitioned table consisting solely of temp= orary partitions is allowed.=E2=80=9D

David J.

= --Apple-Mail-FF602487-752C-49B8-BAA0-B59824AB37B6--