Hi Xavier The temporary table save the description in their system catalog on the disk, but the datas are save in RAM if the memory available given is sufficient,
In this thread, it's not a PostgreSQL problem, but a kernel one. Regards, Christophe. Le 10/02/10 16:54, Xavier Morel a écrit : > On 10 Feb 2010, at 16:45 , Christophe Chauvet wrote: >> >> The TEMPORARY TABLE are create in RAM if the temp_buffer parameter is >> sufficient if not, the table is store on the disk >> >> Christophe. > > There are no guarantees they'll be created in ram, even if temp_buffer is big > enough, unless the temp_tablespace is on a ramdisk. And even if they are > created in ram, temporary tables DDL will more than likely need to update > system tables which are stored on disk. So temporary tables will incur disk > hits either way. > > See http://old.nabble.com/Create-and-drop-temp-table-in-8.3.4-td20347767.html > for (among other things) mentions of these. > > -- > Xavier > > > _______________________________________________ > Mailing list: https://launchpad.net/~openerp-expert-framework > Post to : [email protected] > Unsubscribe : https://launchpad.net/~openerp-expert-framework > More help : https://help.launchpad.net/ListHelp -- Christophe Chauvet Directeur Technique/Technical Manager 27 Avenue Jean Mantelet 61000 Alençon, France http://www.syleam.fr/ _______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-framework Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-framework More help : https://help.launchpad.net/ListHelp
