Re: UNLOGGED TEMPORARY tables?

Поиск
Список
Период
Сортировка
От Lonni J Friedman
Тема Re: UNLOGGED TEMPORARY tables?
Дата
Msg-id CAP=oouHZWWg-6dF2JTnF7RxHB7ZPMSWLkq_6HW3=vbFmVZD=nw@mail.gmail.com
обсуждение исходный текст
Ответ на UNLOGGED TEMPORARY tables?  (aasat <satriani@veranet.pl>)
Ответы Re: UNLOGGED TEMPORARY tables?
Список pgsql-general
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.

On Sun, Mar 24, 2013 at 1:32 PM, aasat <satriani@veranet.pl> wrote:
> I was tested write speed to temporary and unlogged tables and noticed that
> unlogged tables was a much faster
>
> Postgres 9.2.2
>
> Write speed
>
> Temporary 14.5k/s
> UNLOGGED 50k/s
>
> Before test I was convinced that temporary tables in postgres >= 9.1 are
> unlogged
>
>
>
>


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

Предыдущее
От: News Subsystem
Дата:
Сообщение: ...
Следующее
От: Guy Rouillier
Дата:
Сообщение: Re: help me to clear postgres problem