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

On Mon, Jun 23, 2014 at 1:17 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Wed, Jun 18, 2014 at 9:39 PM, Matheus de Oliveira
> <matioli.matheus@gmail.com> wrote:
> >> Then, to summarize Matheus must do:
> >> * use an option instead of change the syntax and catalog to indicate that
> >> a tablespace is used to store temp objects
> >
> > Yes. I myself wasn't sure TEMPORARY syntax would be good, but I would just
> > like to hear more about. Storing as an options seems nice to me.
>
> I kind of like the TEMPORARY syntax, by analogy with what we do for
> tables.  On the other hand, this situation isn't quite analogous: the
> tablespace itself is permanent; it's only the objects inside the
> tablespace that are temporary.  Hmm.
>

The suggested syntax is about "TEMP LOCATION" and not "TEMP TABLESPACE"...

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello

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