"Alexander Todorov" <alexx.todorov@xxxxxxxxx> writes: > is there anything to emulate the MySQL memory table engine? > A straight forward solution is to create a ramfs volume and mount/link > content under /var/lib/postresql there. Then add some scripts to > save/restore databases when the server restarts. > I am wondering is there something else? As long as shared_buffers is high enough, there doesn't seem to be much point in worrying about this; the incremental performance gain will be minimal since everything will be in RAM anyway. Or do you think losing the content of the database at server crash is a feature? regards, tom lane
