Re: How about a proper TEMPORARY TABLESPACE? - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: How about a proper TEMPORARY TABLESPACE?
Date
Msg-id CAFcNs+og7nxgdikDz95QxNdkVv_5X54N-VTYVzJUNvgBDeuMjg@mail.gmail.com
Whole thread Raw
In response to Re: How about a proper TEMPORARY TABLESPACE?  (Matheus de Oliveira <matioli.matheus@gmail.com>)
List pgsql-hackers
<div dir="ltr"><div class="gmail_extra">On Wed, Jun 18, 2014 at 10:39 PM, Matheus de Oliveira <<a
href="mailto:matioli.matheus@gmail.com">matioli.matheus@gmail.com</a>>wrote:<br />><br />> I was going to
answereach message, but Fabrízio summarized everything so far really nicely. Thanks Fabrízio.<br /> ><br /><br
/>You'rewelcome. :-)<br /><br /> <br />><br />> On Wed, Jun 18, 2014 at 5:25 PM, Fabrízio de Royes Mello <<a
href="mailto:fabriziomello@gmail.com">fabriziomello@gmail.com</a>>wrote:<br />>><br />>> Then, to
summarizeMatheus must do:<br /> >> * use an option instead of change the syntax and catalog to indicate that a
tablespaceis used to store temp objects<br />><br />><br />> Yes. I myself wasn't sure TEMPORARY syntax would
begood, but I would just like to hear more about. Storing as an options seems nice to me.<br /> >  <br /><br
/></div><divclass="gmail_extra">Are there somebody that reject this idea? Thoughts?<br /></div><div
class="gmail_extra"><br/><br />>><br />>> * throw an exception if we try ALTER the option
"only_temp_relations"<br/> ><br />><br />> I think we should postpone the ALTER option, perhaps as another
patch.Wasn't that what was decided?<br />><br /><br />Don't worry about that, we can help you. ;-)<br /><br /> <br
/>><br/>> I'll investigate the options better before going this route. Let me work on CREATE first.<br /> ><br
/><br/>See this files:<br />- src/include/commands/tablespace.h (TableSpaceOpts struct at line 35)<br />-
src/backend/access/common/reloptions.c(tablespace_reloptions at line 1333)<br /><br /> <br />>><br />>> *
addregression tests<br /> >> * add documentation<br />>><br />>> And, of course, register to the next
opencommitfest [1] to get detailed feedback and review.<br />><br />><br />> Noted. It will be on the next
commitfest.Just knowing some people do want this make me more comfortable on working better.<br /> ><br /><br
/>Nice...I would like to be a reviewer.<br /><br />Att,<br /><br />--<br />Fabrízio de Royes Mello<br
/>Consultoria/CoachingPostgreSQL<br />>> Timbira: <a
href="http://www.timbira.com.br">http://www.timbira.com.br</a><br/> >> Blog sobre TI: <a
href="http://fabriziomello.blogspot.com">http://fabriziomello.blogspot.com</a><br/>>> Perfil Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/> >> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a></div></div>

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [bug fix] Memory leak in dblink
Next
From: Joe Conway
Date:
Subject: Re: [bug fix] Memory leak in dblink