Re: Postgres as In-Memory Database?

Hi Stefan,

> How can Postgres be used and configured as an In-Memory Database?
>

we've put the data directory on our buildserver directly on a ramdisk (e.g. /dev/shm) to improve build times.

Obviously you then don't care too much about durability here, so one can switch off all related settings (as has
alreadybeen pointed out). The only thing to do on a server reboot would be to re-create a fresh data directory on the
ramdisk.

So if you're able to start from scratch relatively cheap (i.e. on a server reboot), don't care about durability/crash
safetyat all and your database fits into ram that solution is easy to handle.  

I've also tried having only a separate tablespace on ramdisk but abandoned the idea because postgres seemed too
surprisedto see the tablespace empty after a reboot (all tables gone). 

Overall the above solution works and improves our build times but I think there are better ways to have
in-memory/applicationcaches than using a postgres.  

What is your use-case?

Regards
Andreas