mysql hash table equivalent?
Does postgres support in-memory only tables like the mysql HASH table type?
I want to store some session data which I need quick access of, but don't
care of it's lost on server stop/start
"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.
regards, tom lane
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