In-memory table in PostgreSQL

Question

How can I create an in-memory table in PostgreSQL?

Answer 1

Create a RAM disk using software appropriate to your OS. Use CREATE TABLESPACE to create a DB cluster on the RAM disk. When you create your table, use the TABLESPACE clause. Obviously, your RAM tables will not persist across system reboots unless you save the RAM disk.