| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Global temporary tables |
| Date: | 2026-06-22 08:56:54 |
| Message-ID: | CAEZATCU_goy9GiN75Rhqwg8=AEHrujYdf+cF9ORMGg98Tc44YA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, 21 Jun 2026 at 23:06, Andrew Dunstan <andrew(at)dunslane(dot)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
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Basic-support-for-global-temporary-tables.patch | text/x-patch | 135.7 KB |
| v2-0002-Support-indexes-on-global-temporary-tables.patch | text/x-patch | 36.1 KB |
| v2-0003-Support-global-temporary-sequences.patch | text/x-patch | 17.6 KB |
| v2-0004-Support-global-temporary-catalog-tables-and-add-p.patch | text/x-patch | 85.9 KB |
| v2-0005-Add-relation-statistics-columns-to-pg_temp_class.patch | text/x-patch | 42.4 KB |
| v2-0006-Add-relfrozenxid-and-relminmxid-columns-to-pg_tem.patch | text/x-patch | 33.0 KB |
| v2-0007-Add-pg_temp_statistic-global-temporary-catalog-ta.patch | text/x-patch | 33.1 KB |
| v2-0008-Add-pg_temp_statistic_ext_data-global-temporary-c.patch | text/x-patch | 36.7 KB |
| v2-0009-Add-pg_temp_index-global-temporary-catalog-table.patch | text/x-patch | 58.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ewan Young | 2026-06-22 08:57:00 | Re: GRAPH_TABLE: aggregates/window/set-returning functions in COLUMNS crash the backend |
| Previous Message | Heikki Linnakangas | 2026-06-22 08:55:45 | Re: truncating casts of pgoff_t |