Thread: temporary tables on hd or in memory?

temporary tables on hd or in memory?

From
"Stefan Scherf"
Date:
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?

From
Tom Lane
Date:
"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