In addition to the other great comments and advice that have been posted, you might want to review the "Database Compatibility Technology for Oracle" document from EnterpriseDB.
http://www.enterprisedb.com/solutions/oracle-compatibility-technology On Sat, May 9, 2015 at 8:32 AM, Jack Christensen <j...@jackchristensen.com> wrote: > On 05/09/2015 06:33 AM, Stephen Frost wrote: > >> Temporary tables will be in memory unless they overflow work_mem and we >> do support unlogged tables and tablespaces which you could stick out on a >> ramdisk if you want. >> > I would suggest not putting a table space on a ramdisk. According to the > docs this risks corrupting the entire cluster. > > http://www.postgresql.org/docs/9.4/static/manage-ag-tablespaces.html > > Jack > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.