openerp-expert-framework team mailing list archive

[Albert Cervera i Areny <albert@xxxxxxxxxxx>]

IMHO, though interesting, this discussion is out of scope of the bluprint.

The thing is if we want osv_memory to be implemented using PostgreSQL and how.

A Dimecres, 10 de febrer de 2010, Christophe Chauvet va escriure:
> 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
> 


-- 
Albert Cervera i Areny
http://www.NaN-tic.com
Mòbil: +34 669 40 40 18