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 />