Re: In memory Database for postgres

2009/4/13 aravind chandu <avin_friends@yahoo.com>:
>
>
> Hello,
>
>                Thanks for your reply,but what I am actually looking for is
> database should be an in-memory database and at the same i want to store
> that data into disk so that data won't be lost when the system restarts or
> in case of power failure. Can you guys tell me the procedure how to do this?
> your help will he greatly appreciated.
>
> Thanks,
> Avin.
>

Oh, well... there is a way but is not recomended.

So you can make the tables on memory and with a trigger update on disk...
you can call this inverted materialized views (because in general you
update the views on memory but not in the disk).

But there is a problem... if you update on memory and a shutdown
occurs and the trigger didn't start... you lost this record  :( I must
say that you

That's because i prefer have a database in disk and have updatable
views in memory :)


--
      Emanuel Calvo Franco
        Sumate al ARPUG !
      (www.postgres-arg.org -
         www.arpug.com.ar)
    ArPUG / AOSUG Member
   Postgresql Support & Admin