Thread: temporary tables on hd or in memory?

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

"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