Horton

Re: Global temporary tables

Gilles DAROLD <gilles@darold.net>

View thread View on postgr.es
From: Gilles Darold <gilles@darold.net>
To: Dean Rasheed <dean.a.rasheed@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-06-24T04:15:21Z
Lists: 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/

Commits

  1. doc: clarify MERGE PARTITIONS adjacency requirement