Tom Lane <tgl@xxxxxxxxxxxxx> writes: > "Chris St Denis" <chris@xxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster