temporary tables on hd or in memory? 
Author Message
 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?



---------------------------(end of broadcast)---------------------------

Tue, 05 Jul 2005 16:05:52 GMT
 temporary tables on hd or in memory?


> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Tue, 05 Jul 2005 22:50:26 GMT
 [ 2 post ] 

 Relevant Pages 

1. Recover some HD, HUGE temporary file

2. How to create temporary tables in memory

3. Temporary table in memory

4. ORA-04030: out of process memory when trying to allocate 123952 bytes(callheap,temporary memory)

5. How to release unused HD-Memory of datafiles?

6. How temporary are temporary tables?

7. Cannot alter PDX-Table on HD if Application is on CD-ROM

8. Not enough memory for RDF temporary work area

9. DBase IV 2.0 question on temporary memory variables definition

10. Q:temporary in memory (only) berkeley DB

11. Copying the structure of a table into a temporary table without constraint and identities

12. pl/sql table vs. temporary table

Powered by phpBB® Forum Software