Re: update on global temporary and unlogged tables

From: Rob Wultsch <wultsch(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: update on global temporary and unlogged tables
Date: 2010-09-14 01:06:56
Message-ID: AANLkTinqvN_RQSuOHNxCwU5T2V9Fjjx1MFWfhQvoZiVF@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Sep 6, 2010 at 7:55 PM, Robert Haas <robertmhaas(at)gmail(dot)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(at)gmail(dot)com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Itagaki Takahiro 2010-09-14 01:30:25 Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)
Previous Message Fujii Masao 2010-09-14 00:55:21 Re: pg_ctl emits strange warning message