Re: Global temporary tables

Dean Rasheed <dean.a.rasheed@gmail.com>

View thread View on postgr.es

From: Dean Rasheed <dean.a.rasheed@gmail.com>

To: Pavel Stehule <pavel.stehule@gmail.com>

Cc: Andrew Dunstan <andrew@dunslane.net>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2026-06-23T23:34:26Z

Lists: pgsql-hackers

Attachments

v4-0001-Basic-support-for-global-temporary-tables.patch (text/x-patch) patch v4-0001
v4-0002-Support-indexes-on-global-temporary-tables.patch (text/x-patch) patch v4-0002
v4-0003-Support-global-temporary-sequences.patch (text/x-patch) patch v4-0003
v4-0004-Support-global-temporary-catalog-tables-and-add-p.patch (text/x-patch) patch v4-0004
v4-0005-Add-relation-statistics-columns-to-pg_temp_class.patch (text/x-patch) patch v4-0005
v4-0006-Add-relfrozenxid-and-relminmxid-columns-to-pg_tem.patch (text/x-patch) patch v4-0006
v4-0007-Add-pg_temp_statistic-global-temporary-catalog-ta.patch (text/x-patch) patch v4-0007
v4-0008-Add-pg_temp_statistic_ext_data-global-temporary-c.patch (text/x-patch) patch v4-0008
v4-0009-Add-pg_temp_index-global-temporary-catalog-table.patch (text/x-patch) patch v4-0009

On Tue, 23 Jun 2026 at 10:12, Dean Rasheed <dean.a.rasheed@gmail.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

Commits

doc: clarify MERGE PARTITIONS adjacency requirement
- 57f19774d6c8 master cited