Postgres Pro
Downloads
Home   >   mailing lists

Substitute for synonym in Oracle after migration to postgres - Mailing list pgsql-performance

From aditya desai
Subject Substitute for synonym in Oracle after migration to postgres
Date
Msg-id CAN0SRDHKNUrMT9LJ1_mBqcYB5KUvK16d05mBspMx2=h4ry=d6g@mail.gmail.com
Whole thread Raw
Responses Re: Substitute for synonym in Oracle after migration to postgres  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Substitute for synonym in Oracle after migration to postgres  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-performance
Tree view
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 by date:

Previous
From: aditya desai
Date:
Subject: Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS
Next
From: Laurenz Albe
Date:
Subject: Re: Substitute for synonym in Oracle after migration to postgres