temporary tables on hd or in memory?
Started by Stefan Scherfabout 23 years ago2 messagesgeneral
Hi List,
where are temporary tables stored? On the harddisk or in memory?
In MySql you can use heap tables for increasing performance. Is there a
similar thing in postgres?
Greetings
Stefan
Re: temporary tables on hd or in memory?
"Stefan Scherf" <scherf@holyhome.de> writes:
where are temporary tables stored? On the harddisk or in memory?
They're ordinary files, but if you have enough RAM to hold them, the
kernel will usually retain them in kernel disk cache. So we get the
best of both worlds.
regards, tom lane