Well at first I thought that you could create an in-memory tablespace. But it doesn't seem like its a good idea though, http://stackoverflow.com/questions/7872693/running-postgresq...

So I guess if you need in-memory data, SQLite or Redis are better options.

There are other options for in-memory datastores on Linux though, such as Redis.