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

From Laurenz Albe
Subject Re: Substitute for synonym in Oracle after migration to postgres
Date
Msg-id 5fbb9bbf869f1880928f377dbd7e7fd4d167e31b.camel@cybertec.at
Whole thread Raw
In response to Substitute for synonym in Oracle after migration to postgres  (aditya desai <admad123@gmail.com>)
List 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




pgsql-performance by date:

Previous
From: aditya desai
Date:
Subject: Substitute for synonym in Oracle after migration to postgres
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Substitute for synonym in Oracle after migration to postgres