Re: Global temporary tables - Mailing list pgsql-hackers

From Gilles Darold
Subject Re: Global temporary tables
Date
Msg-id 1a08e269-efec-4a64-a4a0-57135669f60f@darold.net
Whole thread
In response to Re: Global temporary tables  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
Le 24/06/2026 à 06:34, Dean Rasheed a écrit :
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


Congratulations, it's an ingenious implementation. Aside from portability with other DBMSs, the fundamental advantage of GTTs is avoiding catalog fragmentation caused by the intensive use of temporary tables. This is what the patch looks to achieve.

I will try to do more checks.

Best regards.

-- 
Gilles Darold
http://hexacluster.ai/

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Add pg_stat_kind_info system view
Next
From: Michael Paquier
Date:
Subject: Re: Improve pg_stat_statements scalability