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 : [email protected] > > 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 _______________________________________________ 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
