Postgres Pro
Downloads
Home   >   mailing lists

Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information - Mailing list pgsql-general

From Melvin Davidson
Subject Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information
Date
Msg-id CANu8Fiw9oyL_OoosZHpr0QgvTavaGPFHcREaou1peOcY5d2iYQ@mail.gmail.com
Whole thread Raw
In response to Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information  (Jack Christensen <jack@jackchristensen.com>)
Responses Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Tree view
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 <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.

pgsql-general by date:

Previous
From: Jack Christensen
Date:
Subject: Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information
Next
From: Bill Moran
Date:
Subject: RPM building tools and info missing?