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+pXpgyUFfGHmHHpqw6JZRhCVN-0BEayWjfeKqPCEBWPCg@mail.gmail.com
Whole thread Raw
In response to Re: How about a proper TEMPORARY TABLESPACE?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
<div dir="ltr"><div class="gmail_extra"><br />On Mon, Jun 23, 2014 at 1:17 PM, Robert Haas <<a
href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>>wrote:<br />><br />> On Wed, Jun 18, 2014 at
9:39PM, Matheus de Oliveira<br /> > <<a href="mailto:matioli.matheus@gmail.com">matioli.matheus@gmail.com</a>>
wrote:<br/>> >> Then, to summarize Matheus must do:<br />> >> * use an option instead of change the
syntaxand catalog to indicate that<br /> > >> a tablespace is used to store temp objects<br />> ><br
/>>> Yes. I myself wasn't sure TEMPORARY syntax would be good, but I would just<br />> > like to hear more
about.Storing as an options seems nice to me.<br /> ><br />> I kind of like the TEMPORARY syntax, by analogy with
whatwe do for<br />> tables.  On the other hand, this situation isn't quite analogous: the<br />> tablespace
itselfis permanent; it's only the objects inside the<br /> > tablespace that are temporary.  Hmm.<br />><br /><br
/>Thesuggested syntax is about "TEMP LOCATION" and not "TEMP TABLESPACE"...<br /><br /></div><div
class="gmail_extra">Regards,<br/><br /></div><div class="gmail_extra"> --<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: Greg Stark
Date:
Subject: Re: Extended Prefetching using Asynchronous IO - proposal and patch
Next
From: Tom Lane
Date:
Subject: Re: autovacuum scheduling starvation and frenzy