Skip site navigation (1) Skip section navigation (2)

Re: idea: global temp tables

From: James Mansion <james(at)mansionfamily(dot)plus(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Greg Stark <stark(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: idea: global temp tables
Date: 2009-04-30 19:26:02
Message-ID: 49F9FB4A.7080809@mansionfamily.plus.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Kevin Grittner wrote:
> contexts.  I don't think the updates to the system tables have the
> same magnitude of performance hit as creating these tables, especially
> if write barriers are on.
>   
Wouldn't it be cleaner just to defer creation of real files to support the
structures associated with a temp table until it i snecessary to spill the
data from the backend's RAM?  This data doesn't need to be in
shared memory and the tables and data aren't visible to any other
session, so can't they run out of RAM most of the time (or all the
time if the data in them is short lived)?



In response to

Responses

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2009-04-30 19:32:20
Subject: Re: idea: global temp tables
Previous:From: David FetterDate: 2009-04-30 19:11:00
Subject: Re: Keyword list sanity check

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group