public inbox for [email protected]  

help / color / mirror / Atom feed

From: Konstantin Knizhnik <[email protected]>
To: Pavel Stehule <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: Tomas Vondra <[email protected]>
Cc: 曾文旌(义从) <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: 蔡松露(子嘉) <[email protected]>
Cc: Cai, Le <[email protected]>
Cc: 萧少聪(铁庵) <[email protected]>
Subject: Re: [Proposal] Global temporary tables
Date: Wed, 29 Jan 2020 20:21:20 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFj8pRB50gSeoNqnkqYkHMN3V74RQFRMPwCkkO9bseFgVLn32Q@mail.gmail.com>
References: <[email protected]>
	<[email protected]>
	<20200112015109.caab6qdr2ob6d5jv@development>
	<CA+TgmobRhPA1gVbMsj9YLA-sv0Ub8NpMrkWCKwRiD=bnjVND3Q@mail.gmail.com>
	<[email protected]>
	<CAFj8pRAB4Ni+CL6n9QZ24wdp6n_2TLb2hYm60hs_KVXnDzN8tw@mail.gmail.com>
	<[email protected]>
	<CAFj8pRARb4BiT9Nb-YFg2h+EdbVQt8FY=L0utGM_FL6T-gjc-w@mail.gmail.com>
	<[email protected]>
	<CAFj8pRAvegZoQCLw3vjHZ=6_Kr7-1UAA5QgGYOshhXU6j_RuCg@mail.gmail.com>
	<[email protected]>
	<CAFj8pRDVaNQhg1juJKuj3A2fN-TW5LsMVCqyOkEhKKjbjHEk5w@mail.gmail.com>
	<[email protected]>
	<CA+TgmobN=o7d4zTJywJzsvkCeL4-_3ttWK_dhzpt-P3yCJ=77w@mail.gmail.com>
	<[email protected]>
	<CAFj8pRB50gSeoNqnkqYkHMN3V74RQFRMPwCkkO9bseFgVLn32Q@mail.gmail.com>



On 29.01.2020 20:08, Pavel Stehule wrote:
>
>
>
>     2. Actually I do not propose some completely new approach. I try to
>     provide behavior with is compatible with regular tables.
>     If you create index for regular table, then it can be used in all
>     sessions, right?
>
>
> I don't understand to this point. Regular tables shares data, shares 
> files. You cannot to separate it. More - you have to uses relatively 
> aggressive locks to be this operation safe.
>
> Nothing from these points are valid for GTT.

GTT shares metadata.
As far as them are not sharing data, then GTT are safer than regular 
table, aren't them?
"Safer" means that we need less "aggressive" locks for them: we need to 
protect only metadata, not data itself.

My point is that if we allow other sessions to access created indexes 
for regular tables, then it will be not more complex to support it for GTT.
Actually "not more complex" in this case means "no extra efforts are 
needed".

-- 
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

view thread (492+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: [Proposal] Global temporary tables
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox