Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information
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
http://www.enterprisedb.com/solutions/oracle-compatibility-technology
On Sat, May 9, 2015 at 8:32 AM, Jack Christensen <jack@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.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
В списке pgsql-general по дате отправления: