Re: Schemas and Search Path

2023-03-20 Thread Ron Johnson
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? >

Re: Schemas and Search Path

2023-03-20 Thread Pavel Stehule
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

Schemas and Search Path

2023-03-20 Thread DAVID ROTH
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 m