Re: update on global temporary and unlogged tables

<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 />