Re: update on global temporary and unlogged tables - Mailing list pgsql-hackers

From Rob Wultsch
Subject Re: update on global temporary and unlogged tables
Date
Msg-id AANLkTinqvN_RQSuOHNxCwU5T2V9Fjjx1MFWfhQvoZiVF@mail.gmail.com
Whole thread Raw
In response to update on global temporary and unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: update on global temporary and unlogged tables
List 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 by date:

Previous
From: Fujii Masao
Date:
Subject: Re: pg_ctl emits strange warning message
Next
From: Itagaki Takahiro
Date:
Subject: Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)