Re: temporary tables on hd or in memory? - Mailing list pgsql-general

From Tom Lane
Subject Re: temporary tables on hd or in memory?
Date
Msg-id 7795.1042814991@sss.pgh.pa.us
Whole thread Raw
In response to temporary tables on hd or in memory?  ("Stefan Scherf" <scherf@holyhome.de>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Emmanuel Charpentier
Date:
Subject: Strange error accessing *views* from Linux through ODBC
Next
From: "Claudio Lapidus"
Date:
Subject: Re: Translation of the PostgreSQL manuals to Spanish is under way