Re: Global temporary tables
Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
From: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Craig Ringer <craig@2ndquadrant.com>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2019-09-20T15:12:46Z
Lists: pgsql-hackers
Attachments
- global_shared_temp_replica-2.patch (text/x-patch) patch
I have added support of all indexes (brin, btree, gin, gist, hash, spgist) for global temp tables (before only B-Tree index was supported). It will be nice to have some generic mechanism for it, but I do not understand how it can look like. The problem is that normal relations are initialized at the moment of their creation. But for global temp relations metadata already exists while data is absent. We should somehow catch such access to not initialized page (but not not all pages, but just first page of relation) and perform initialization on demand. New patch for global temp tables with shared buffers is attached. -- Konstantin Knizhnik Postgres Professional: http://www.postgrespro.com The Russian Postgres Company