Daniel Westermann wrote: > is someone using temporary tablespaces on a RAM disk ? Any experiences with > that?
> I did some quick tests and checked the archives but could not find any > information that either confirmed it is a bad idea nor the opposite. >Well, we point our "stats_temp_directory" to a tmpfs partition, which is >probably fairly common (or so I'd guess). >But a full tablespace with tables and everything? That sounds pretty risky for >anything other than a place to store >data for transformation or summary of data that could be recreated by >restarting a process if the server goes down >in the middle. >I think you'd be better off explaining what your goal is and then people could >give you better comments. Thank you for the hint with stats_temp_directory. I am only talking about temp_tablespaces which are supposed for temporary objects only. It is pretty clear not to use that for persistent objects, I know. Regards Daniel
