Re: Schemas and Search Path
Please don't hijack threads. https://www.postgresql.org/docs/13/limits.html No mention of schemas. On Mon, Mar 20, 2023 at 12:08 PM DAVID ROTH wrote: > 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? > > Thanks > Dave Roth > > On 03/20/2023 10:15 AM Ron Johnson 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 > 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* > >
Re: Schemas and Search Path
Hi po 20. 3. 2023 v 17:08 odesílatel DAVID ROTH 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 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 > 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* > >
Schemas and Search Path
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? Thanks Dave Roth > On 03/20/2023 10:15 AM Ron Johnson 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 > mailto:inzamam.sha...@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 > > > > > > >