Re: UNLOGGED TEMPORARY tables?

Поиск
Список
Период
Сортировка
От Lonni J Friedman
Тема Re: UNLOGGED TEMPORARY tables?
Дата
Msg-id CAP=oouFGoU=FK+WqD+zZt0e1xi4-DHsX=aXj3ffuPOAY_64=Nw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: UNLOGGED TEMPORARY tables?  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-general
On Mon, Mar 25, 2013 at 4:49 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
>
>
> On Tue, Mar 26, 2013 at 8:26 AM, Lonni J Friedman <netllama@gmail.com>
> wrote:
>>
>> I'm pretty sure that unlogged tables and temp tables are two separate
>> & distinct features, with no overlap in functionality.  It would be
>> nice if it was possible to create an unlogged temp table.
>
> Temporary tables are a subtype of unlogged tables, as temporary tables are
> not WAL-logged.
> This article from Robert Haas will give a good summary of such differences:
> http://rhaas.blogspot.jp/2010/05/global-temporary-and-unlogged-tables.html


Thanks, that's good to know.  the official dox don't really make it
clear that temp tables are unlogged.


В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: UNLOGGED TEMPORARY tables?
Следующее
От: Misa Simic
Дата:
Сообщение: Re: PostgreSQL and VIEWS