Question about TEMP tables

From: Dmitry Voronin <carriingfate92(at)yandex(dot)ru>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Question about TEMP tables
Date: 2015-03-16 08:31:29
Message-ID: 6629611426494689@web14g.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

<div>Hello, all.<br /><br />We can create temp namespaces and temp objects that contains it. So, for example, temp table will be create at pg_temp_N (N - backendID). But afrer cluster init we have pg_temp_1 and pg_toast_temp_1 namespaces with OIDs 11333 and 11334. Those namespaces are <span lang="en"><span>visible from any cluster database, but we cannot create any temp objects (please, correct me). <br /><br />So, how can we use those namespaces and </span></span><span lang="en"><span>what are needed for?</span></span></div><div> </div><div><span lang="en"><span>Thank you.</span></span></div><div> </div><div>-- </div><div>Best regards, Dmitry Voronin</div><div> </div>

Attachment Content-Type Size
unknown_filename text/html 680 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2015-03-16 09:55:13 Re: Removing INNER JOINs
Previous Message Kyotaro HORIGUCHI 2015-03-16 08:28:55 Re: Performance improvement for joins where outer side is unique