Tom Lane <tgl@sss.pgh.pa.us> writes:
> "Chris St Denis" <chris@aebc.com> writes:
>> Does postgres support in-memory only tables like the mysql HASH table type?
>
> No, and it doesn't seem particularly necessary: a table that is being
> hit heavily will stay in cache buffers anyhow. You don't need any
> special mechanism.
And if you're really concerned about speed, you should be caching it
in application memory and saving the IPC round trip and the SQL
parsing overhead...
-Doug