"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