Re: How to add function schema in search_path in option definitio

On 7/8/23 10:00, Lorusso Domenico wrote: Hello Adrian, I've created a schema to handle some specific features. In the schema there are a couple of tables used by many functions (more than 20). In other words, I've created a schema as a package (as suggested in many points). I wish, in a funct

Re: How to add function schema in search_path in option definitio

Hello Adrian, I've created a schema to handle some specific features. In the schema there are a couple of tables used by many functions (more than 20). In other words, I've created a schema as a package (as suggested in many points). I wish, in a function of this schema, to be able to call each ot

Re: How to add function schema in search_path in option definitio

On 7/8/23 08:06, Lorusso Domenico wrote: Hello guys, there is a comfortable way to add the schema of the function as in search path? something like create my_schema.function() as $body$...$body$ set search_path to function_schema() || search_path You can do something like: show search_pat

Re: How to add function schema in search_path in option definitio

On 7/8/23 08:06, Lorusso Domenico wrote: Hello guys, there is a comfortable way to add the schema of the function as in search path? something like create my_schema.function() as $body$...$body$ set search_path to function_schema() || search_path 1) Do you want this to happen inside function

How to add function schema in search_path in option definitio

Hello guys, there is a comfortable way to add the schema of the function as in search path? something like create my_schema.function() as $body$...$body$ set search_path to function_schema() || search_path -- Domenico L. per stupire mezz'ora basta un libro di storia, io cercai di imparare la Tr

Re: pgbouncer best practices

Rita wrote on 7/8/23 4:27 AM: I am not sure if it allows transaction pooling. Well, take the time to figure it out. With transaction pooling enabled, you can get away with a much lower number of server connections. For example, our application regularly has thousands of clients connected to

Re: pgbouncer best practices

I am not sure if it allows transaction pooling. On Fri, Jul 7, 2023 at 12:37 PM Ben Chobot wrote: > Rita wrote on 7/7/23 9:23 AM: > > I have an application that does many db calls from a server farm. I've > increased my max connections on postgresql to 1000 and tuned the server > accordingly.