Substitute for synonym in Oracle after migration to postgres

From: aditya desai <admad123(at)gmail(dot)com>
To: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Substitute for synonym in Oracle after migration to postgres
Date: 2021-04-06 07:52:31
Message-ID: CAN0SRDHKNUrMT9LJ1_mBqcYB5KUvK16d05mBspMx2=h4ry=d6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2021-04-06 08:19:32 Re: Substitute for synonym in Oracle after migration to postgres
Previous Message aditya desai 2021-04-06 05:09:27 Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS