Re: RAM-only temporary tables - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: RAM-only temporary tables
Date
Msg-id 20081106171620.GM5520@alvh.no-ip.org
Whole thread Raw
In response to Re: RAM-only temporary tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

> One place that I've always wanted to look at was suppressing the
> creation of a btree metapage until there's some useful data in the
> table.  We managed to avoid creating a root page until there's data,
> but at the time avoiding the metapage seemed too invasive.  (Admittedly,
> though, if one assumes that your real world case does involve putting
> some data in the tables, this wouldn't actually save anything...)

Agreed on the parenthised comment -- it'd be just benchmark
optimization.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: plperl needs upgrade for Fedora 10
Next
From: Josh Berkus
Date:
Subject: Re: My review for the patch "Table command"