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
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
On Mon, Sep 6, 2010 at 7:55 PM, Robert Haas <robertmhaas@gmail.com> wrote:
3. With respect to unlogged tables, the major obstacle seems to be
figuring out a way for these to get automatically truncated at startup
time.

(please forgive what is probably a stupid question)
By truncate do mean reduce the table to a very small number (or zero) number of pages? Is there a case to be made for instead somehow marking all pages as available for reuse? Deallocating and reallocating space can be expensive.

--
Rob Wultsch
wultsch@gmail.com

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)