Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> "Chris St Denis" <chris(at)aebc(dot)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