Re: Substitute for synonym in Oracle after migration to postgres

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: aditya desai <admad123(at)gmail(dot)com>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Substitute for synonym in Oracle after migration to postgres
Date: 2021-04-06 08:19:32
Message-ID: 5fbb9bbf869f1880928f377dbd7e7fd4d167e31b.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 2021-04-06 at 13:22 +0530, aditya desai wrote:
> We have to access data from one schema to another. We have created
> a view for this but performance is not good.

The performance of a view that is just a simple SELECT to a table
in a different schema will be just as good as using that table
directly.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message hubert depesz lubaczewski 2021-04-06 10:41:48 Re: Substitute for synonym in Oracle after migration to postgres
Previous Message aditya desai 2021-04-06 07:52:31 Substitute for synonym in Oracle after migration to postgres