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 1wDzgf-003Yfa-0b for pgsql-docs@arkaria.postgresql.org; Sat, 18 Apr 2026 07:01:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wDzgd-00CNAy-3C for pgsql-docs@arkaria.postgresql.org; Sat, 18 Apr 2026 07:01:52 +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.96) (envelope-from ) id 1wDzgd-00CNAq-2T for pgsql-docs@lists.postgresql.org; Sat, 18 Apr 2026 07:01:51 +0000 Received: from mail-yx1-xb12c.google.com ([2607:f8b0:4864:20::b12c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wDzgb-00000001mGn-35pK for pgsql-docs@lists.postgresql.org; Sat, 18 Apr 2026 07:01:51 +0000 Received: by mail-yx1-xb12c.google.com with SMTP id 956f58d0204a3-6501c9903edso1555441d50.1 for ; Sat, 18 Apr 2026 00:01:48 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776495707; cv=none; d=google.com; s=arc-20240605; b=RwNcmM6Qt76g71A/NjoWyuaWr08hD4hmAr9MyAYLON66iguDtq6wVH2ux8G2OJEjgS C2U2vogQ6xwZL1VzQTU4/OjhX+cuMvfJTxnqhWb7WuEFavHr8mzGvCV+/D1RqcvoM3Om sYEj629JAsrzrSaW277sDfb9OM2RY5dRk9WdWGqmmQVM5sPX58DqDioorxJcA2siOsDo /jAVhcnsn6B67qUGLc+PqCmLCIJG6ArRrf+Yt3fJC71ULigEhJ3PtEm2Ewp/Rugn4XiP ZlvugrZwYCwpwFL61Hz6i1Qaeo3IrETxRuhw/Rj3diq6lqvtexiaBAzykavPnVmfWmw3 +H+w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=/Zuc5wnFGnPaCfGmhr3S4Ut7Y5JgKgbbQuPBkIBDlVM=; fh=MZCCUItpFjmoL6kMXIatXvagWqIPIdtRn+VZgaRhXE8=; b=O5vSCsTHk/UAjRnzlecn5WY0pAe8gFMm7GiuPrl6JPh+A+kiv8ewE9ZgtdboYVwWki zYDV9860nkeD+mCDhCz4YeLJmEVlyTTuIAkmCYvAoRcnABrwgv6xIHwKqJzbJIWPXQcS E4QoDpHL++mAS6idetJRRXimpXWj42IL/0co0eQdI4wuIQ8D+0B2Gz2CyWxbuf804wLt fPNMbQKW+jUmfan5jLCxFs5EJ7paj2hApECRS8z3bzhotDcYwWhrxCvO4D+g7hlMlob3 Apsnm7wMhfttI09B0xGSmxO3RuOdAIZK8XzRtjs9bXDw8Yw4eh0EAcKwyhStb8TDGoaa Rpjw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776495707; x=1777100507; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=/Zuc5wnFGnPaCfGmhr3S4Ut7Y5JgKgbbQuPBkIBDlVM=; b=FTa+CIMEDZDGfHl3sIOammwoTS4L6IBxZ7lzPrKhMpTiLjJBDnpQgISVmaapNvi2uK 4+xnj73HH6DALbk8lW7sxwTKXYSCcABA3H7PVaK9VMAS4jD4NwqQKQG1+kkj6KyZirRv oRgTpT9r4D9gYNLYLJUh5WCVv43aArDBzBxVCsGAUxzBo/zEY4Gj/Zj5xP0Sl+PNMKi8 KvuwsTs2lcTklLDu6XNOlOoi/5lnccm0QNnLtI07Sqc2uVyOVtCI2URmgxbvrRCDWQYa h0nFC3o2CRbk6o7pOaQt4+d6t0V2/vk84k8kxqv/XQ9jbcgpCJawV8eUOFLcgaYZy3qQ e9fw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776495707; x=1777100507; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=/Zuc5wnFGnPaCfGmhr3S4Ut7Y5JgKgbbQuPBkIBDlVM=; b=V2/xX3WfsWJ00m27n/hiwicGiplH3xjEnIK4um7OJTSQ7XtdqNPH3Fl5L89PrNscGI 5x4yESiTaei5H7kwOe2udtGRV8fguzh7mSA9OxvHwfR78j9PzCdME640qGQrM7MOllMt 5W3Qv+D0vKMdixmZq1wKckE8F1bz5303sRRl0nqsUkoSjpngVIq/8vT2ZL/XHLLbEm0M nuAdeGuOsXBuLwxDAKfIeFd63/Gzps6qPqWZdn+EInYI/mKHactCzf3we+l1eK6tzTAV sRUUtoSoPuoVevOatyaxW7ziarKDPHDnOo4s9qyWGH0YdJLNQLDRSQaKSKJDUKFtxBIq V8mw== X-Gm-Message-State: AOJu0YzvWQ2mgnClBv9mfOPVohdMq1SUAdbibfyBbpf2wlQdIpoBcdmO EYk3ZZ12P9euCAALeFrJml81PqtbXQSpyx53rgLwup58IbmuYdTEUHxE+nS44HOlMPhcbA3/I5W yOzWx+ShiW7DXUkg30kjJ4NO1gUsAvZg= X-Gm-Gg: AeBDieuPzLjEvPcQDMGoJv7VQzhp7tadoELQl8Ziw9+NDIkL/MeUQ46rld8wrRQ3Q1f cxMT3KMyrM7U/YZqAFqAnOkuW8Ixe1m3D5LV8/aeWODcP2UBiPE3DxULEdTkhn7n6tXwupjDhEX f4Lr9oMvtdi6AY/EhhhpHXw4aU5kaiQDliD/wFH/6p00C5AeQcauMglZQBWSHP/xqn+B8hQ5pGj uUEx5xBK9/Z2Tyus8TqMmma/VYlMDtQHqBOZfKHZlEwN8cuxvSu0vNIkLsH9WOefpI1iInD9Eex NNmXCtVlRjsK27VxjA== X-Received: by 2002:a53:d015:0:b0:652:cacb:ba15 with SMTP id 956f58d0204a3-65310b7b907mr4565070d50.64.1776495706875; Sat, 18 Apr 2026 00:01:46 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:7010:a08c:b0:513:bf0b:1096 with HTTP; Sat, 18 Apr 2026 00:01:45 -0700 (PDT) In-Reply-To: <2B3F5BD8-E69B-4017-B1D0-4ABEF8C967B1@gmail.com> References: <2B3F5BD8-E69B-4017-B1D0-4ABEF8C967B1@gmail.com> From: "David G. Johnston" Date: Sat, 18 Apr 2026 00:01:45 -0700 X-Gm-Features: AQROBzDOTsQPIUcJcTiweqfG-dtxUaeym92386lm4l053v5L2FX6pBkArMsvnIU Message-ID: Subject: Re: Temporary tables and Write-Ahead Log To: =?UTF-8?Q?V=C3=ADctor_Herraiz_Posada?= Cc: "pgsql-docs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000008daa73064fb6a304" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008daa73064fb6a304 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, April 17, 2026, V=C3=ADctor Herraiz Posada wrote: > In create table documentation is not clear if temporary tables use the > write-ahead log. Could you please add a sentence about that like in the > unlogged tables? > The word =E2=80=9Ctemporary=E2=80=9D is communicating the entire first para= graph 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 like an unlog= ged table - though a partitioned table consisting solely of temporary partitions is allowed.=E2=80=9D David J. --0000000000008daa73064fb6a304 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, April 17, 2026, V=C3=ADctor Herraiz Posada <victor.herraiz@gmail.com> wrote:
In create table documentation is not clear if tem= porary tables use the write-ahead log. Could you please add a sentence abou= t that like in the unlogged tables?

The word =E2=80=9Ctemporary=E2=80=9D is co= mmunicating 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 mu= ch like an unlogged table - though a partitioned table consisting solely of= temporary partitions is allowed.=E2=80=9D

David J= .

--0000000000008daa73064fb6a304--