Substitute for synonym in Oracle after migration to postgres

Поиск
Список
Период
Сортировка
От aditya desai
Тема Substitute for synonym in Oracle after migration to postgres
Дата
Msg-id CAN0SRDHKNUrMT9LJ1_mBqcYB5KUvK16d05mBspMx2=h4ry=d6g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Substitute for synonym in Oracle after migration to postgres
Re: Substitute for synonym in Oracle after migration to postgres
Список pgsql-performance
Дерево обсуждения
Hi,
We have to access data from one schema to another. We have created a view for this but performance is not good. We tried materialized views as well but Refresh MV is creating problem as it puts and access exclusive locks.

Is there any other way to achieve this?


Regards,
Aditya.

В списке pgsql-performance по дате отправления:

Предыдущее
От: aditya desai
Дата:
Сообщение: Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Substitute for synonym in Oracle after migration to postgres