Re: Schemas and Search Path

Hi


po 20. 3. 2023 v 17:08 odesílatel DAVID ROTH <adaptron@comcast.net> napsal:

> Is there any practical limit on the number of schemas in a database?
> Will the number of schemas in a user's search path impact performance?
>

Sure, it should have an impact. When you use an unqualified identifier,
then the identifier is searched sequentially in schemas in the search path.
With a large number of schemas in the search path, the planning time can be
higher (and memory usage for cache of system objects can be higher too).

Regards

Pavel





>
> Thanks
> Dave Roth
>
> On 03/20/2023 10:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>
>
> Real-time CDC is the difficult part.  ora2pg (using views) can do a static
> migration.  No coding (unless you consider clever use of bash to modify
> config files to be coding).  I used it to migrate a 7TB db to Postgresql.
>
> https://ora2pg.darold.net/
>
> On Mon, Mar 20, 2023 at 8:58 AM Inzamam Shafiq <inzamam.shafiq@hotmail.com>
> wrote:
>
> Hi,
>
> Hope everyone is fine.
>
> Can someone help or guide regarding Open Source tools for Oracle to
> PostgreSQL migration with real time CDC. along with this is there any
> possibility to change the structure of the database? Let me explain a
> little more,
>
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform data
> transformation and real time CDC from Oracle to PostgreSQL. Do we have any
> good open source tool to achieve this with No Coding involved.??
>
> Thanks.
>
> Regards,
>
> *Inzamam Shafiq*
> *Sr. DBA*
>
>