Substitute for synonym in Oracle after migration to postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Substitute for synonym in Oracle after migration to postgres
From: aditya desai <admad123@xxxxxxxxx>
Date: Tue, 6 Apr 2021 13:22:31 +0530

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.

Follow-Ups:
- Re: Substitute for synonym in Oracle after migration to postgres
  - From: hubert depesz lubaczewski
- Re: Substitute for synonym in Oracle after migration to postgres
  - From: Laurenz Albe

Prev by Date: Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS
Next by Date: Re: Substitute for synonym in Oracle after migration to postgres
Previous by thread: PosgtgreSQL hot standby reading WAL from muli-attached volume?
Next by thread: Re: Substitute for synonym in Oracle after migration to postgres
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux