> 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.