Re: update on global temporary and unlogged tables

Поиск
Список
Период
Сортировка
От Rob Wultsch
Тема Re: update on global temporary and unlogged tables
Дата
Msg-id AANLkTinqvN_RQSuOHNxCwU5T2V9Fjjx1MFWfhQvoZiVF@mail.gmail.com
обсуждение исходный текст
Ответ на update on global temporary and unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: update on global temporary and unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
<div class="gmail_quote">On Mon, Sep 6, 2010 at 7:55 PM, Robert Haas <span dir="ltr"><<a
href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="margin:0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> 3. With respect to
unloggedtables, the major obstacle seems to be<br /> figuring out a way for these to get automatically truncated at
startup<br/> time.<br /></blockquote></div><br />(please forgive what is probably a stupid question)<br />By truncate
domean reduce the table to a very small number (or zero) number of pages? Is there a case to be made for instead
somehowmarking all pages as available for reuse? Deallocating and reallocating space can be expensive.<br clear="all"
/><br/>-- <br />Rob Wultsch<br /><a href="mailto:wultsch@gmail.com">wultsch@gmail.com</a><br /> 

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: pg_ctl emits strange warning message
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)