Re: Global temporary tables

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Global temporary tables
Date: 2026-06-23 23:34:26
Message-ID: CAEZATCUdg2tGj1OWbSWMCubrQdXpGirQkdXNgQBgGf-UQG2hGA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 23 Jun 2026 at 10:12, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:
>
> v3 attached, attempting to fix another issue reported by the cfbot --
> need to tolerate relation_open() on a global temporary relation, when
> in parallel mode because pg_get_viewdef() does that.

Ugh, that still wasn't quite right. Here's v4 with more fixes for
parallel workers.

Regards,
Dean

Attachment Content-Type Size
v4-0001-Basic-support-for-global-temporary-tables.patch text/x-patch 137.6 KB
v4-0002-Support-indexes-on-global-temporary-tables.patch text/x-patch 36.2 KB
v4-0003-Support-global-temporary-sequences.patch text/x-patch 17.6 KB
v4-0004-Support-global-temporary-catalog-tables-and-add-p.patch text/x-patch 86.3 KB
v4-0005-Add-relation-statistics-columns-to-pg_temp_class.patch text/x-patch 42.4 KB
v4-0006-Add-relfrozenxid-and-relminmxid-columns-to-pg_tem.patch text/x-patch 33.0 KB
v4-0007-Add-pg_temp_statistic-global-temporary-catalog-ta.patch text/x-patch 33.1 KB
v4-0008-Add-pg_temp_statistic_ext_data-global-temporary-c.patch text/x-patch 36.7 KB
v4-0009-Add-pg_temp_index-global-temporary-catalog-table.patch text/x-patch 60.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tristan Partin 2026-06-23 23:39:30 Protect against timestamp underflow in uuidv7(interval)
Previous Message Bharath Rupireddy 2026-06-23 23:33:11 Re: Handle concurrent drop when doing whole database vacuum