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

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information
Дата
Msg-id CANu8Fiw9oyL_OoosZHpr0QgvTavaGPFHcREaou1peOcY5d2iYQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information  (Jack Christensen <jack@jackchristensen.com>)
Ответы Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Jack Christensen
Дата:
Сообщение: Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information
Следующее
От: Bill Moran
Дата:
Сообщение: RPM building tools and info missing?