RE: Temporary tablespaces on a RAM disk

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.

HTH,

Kevin

 .