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

Temporary tables and in-memory use

From: Marios Vodas <mvodas(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Temporary tables and in-memory use
Date: 2011-09-29 16:47:53
Message-ID: CAMuJg2SnL78C7kWE4Fu8c7NUEFW_bf-4G2c9-4Sa=fMLV4bLqA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello,

If I'm not wrong, temporary tables stay in memory if they do not go over
temp_buffers limit (e.g. if temp_buffers is 2GB and the size of the table is
300MB the table will remain in memory).
What if a column is variable length (e.g. text), how does this column stay
in-memory since it should be stored in TOAST?
When I build a GiST index on a temporary table does the index stay in memory
as well?

Thank you,
Marios

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2011-09-29 16:55:29
Subject: Re: Temporary tables and in-memory use
Previous:From: Alvaro HerreraDate: 2011-09-29 15:58:41
Subject: have SLRU truncation use callbacks

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