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
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2011-09-29 16:55:29|
|Subject: Re: Temporary tables and in-memory use |
|Previous:||From: Alvaro Herrera||Date: 2011-09-29 15:58:41|
|Subject: have SLRU truncation use callbacks|