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: Andrew Dunstan <andrew@dunslane.net>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2026-06-22T08:56:54Z

Lists: pgsql-hackers

Attachments

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

On Sun, 21 Jun 2026 at 23:06, Andrew Dunstan <andrew@dunslane.net> wrote:
>
> Wow, we're on the same track. I have a patch series for exactly this
> feature that I was about to submit.
>
> FTR here's where I'm at. I'll try to take a look at yours ASAP.

Oh, wow. There's a lot of similarity between our patchsets, which is
reassuring, but there are also a number of differences, which I need
to think about in more detail.

In the meantime, here's a v2 of my patchset fixing up a few things
noted by the cfbot, and one bug I spotted -- REPACK/VACUUM FULL on a
global temporary table with associated toast tables failed if the
table hadn't already been opened in the session, because the code in
repack.c didn't open toast tables, so they were never being
initialized.

Regards,
Dean

Commits

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