Postgres now has UNLOGGED tables which are pretty similar to memory tables.