openerp-expert-framework team mailing list archive

[Christophe Chauvet <christophe.chauvet@xxxxxxxxx>]

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     : openerp-expert-framework@xxxxxxxxxxxxxxxxxxx
> 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/