Temporary tables and in-memory use - Mailing list pgsql-hackers

From Marios Vodas
Subject Temporary tables and in-memory use
Date
Msg-id CAMuJg2SnL78C7kWE4Fu8c7NUEFW_bf-4G2c9-4Sa=fMLV4bLqA@mail.gmail.com
Whole thread Raw
Responses Re: Temporary tables and in-memory use
List pgsql-hackers
Hello,<br /><br />If I'm not wrong, temporary tables stay in memory if they do not go over temp_buffers limit (e.g. if
temp_buffersis 2GB and the size of the table is 300MB the table will remain in memory).<br />What if a column is
variablelength (e.g. text), how does this column stay in-memory since it should be stored in TOAST?<br /> When I build
aGiST index on a temporary table does the index stay in memory as well?<br /><br />Thank you,<br />Marios<br /> 

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: have SLRU truncation use callbacks
Next
From: Tom Lane
Date:
Subject: Re: Temporary tables and in-memory use