On 11/19/10 15:49, Andy Colson wrote:
> unlogged will only help insert/update performance. Lookup tables sound
> readonly for a majority of time. (I'm assuming lots of reads and every
> once and a while updates). I doubt that unlogged tables would speed up
> lookup tables.
Are FreeBSD's temp tables still storage-backed? (i.e. are there
memory-backed temp tables)?