Re: Pipeline Mode vs Single Row Mode / Chunked Rows Mode

2025-01-02 Thread Dominique Devienne
On Thu, Dec 19, 2024 at 3:37 PM Daniel Frey wrote: > I'm adding support for Pipeline Mode to my C++ PostgreSQL client library [...] > Anyway, is there some documentation about how these modes interact and how > they can be combined? Or should they never be combined? Hi. Happy New Year. I was int

Re: search_path for PL/pgSQL functions partially cached?

2025-01-02 Thread Pavel Stehule
Hi čt 2. 1. 2025 v 11:37 odesílatel Jan Behrens napsal: > On Wed, 1 Jan 2025 11:19:32 -0700 > "David G. Johnston" wrote: > > > On Wed, Jan 1, 2025 at 10:55 AM Jan Behrens > wrote: > > > > > On Sat, 28 Dec 2024 00:40:09 +0100 > > > Jan Behrens wrote: > > > > > > > On Fri, 27 Dec 2024 13:26:28

Re: search_path for PL/pgSQL functions partially cached?

2025-01-02 Thread Jan Behrens
On Wed, 1 Jan 2025 11:19:32 -0700 "David G. Johnston" wrote: > On Wed, Jan 1, 2025 at 10:55 AM Jan Behrens wrote: > > > On Sat, 28 Dec 2024 00:40:09 +0100 > > Jan Behrens wrote: > > > > > On Fri, 27 Dec 2024 13:26:28 -0700 > > > "David G. Johnston" wrote: > > > > > > > > Or is it documented s

Re: search_path for PL/pgSQL functions partially cached?

2025-01-02 Thread Jan Behrens
On Thu, 2 Jan 2025 13:48:29 +0100 Pavel Stehule wrote: > čt 2. 1. 2025 v 13:15 odesílatel Jan Behrens > napsal: > > > On Thu, 2 Jan 2025 12:40:59 +0100 > > Pavel Stehule wrote: > > > > > How can you identify unwanted usage of non qualified identifiers from > > > wanted usage of non qualified i

Re: search_path for PL/pgSQL functions partially cached?

2025-01-02 Thread Pavel Stehule
čt 2. 1. 2025 v 13:15 odesílatel Jan Behrens napsal: > On Thu, 2 Jan 2025 12:40:59 +0100 > Pavel Stehule wrote: > > > How can you identify unwanted usage of non qualified identifiers from > > wanted usage of non qualified identifiers? It is a common pattern for > > sharding. Using not qualified

Re: search_path for PL/pgSQL functions partially cached?

2025-01-02 Thread Jan Behrens
On Thu, 2 Jan 2025 12:40:59 +0100 Pavel Stehule wrote: > How can you identify unwanted usage of non qualified identifiers from > wanted usage of non qualified identifiers? It is a common pattern for > sharding. Using not qualified identifiers of operators, functions is common > when you are using

Re: search_path for PL/pgSQL functions partially cached?

2025-01-02 Thread Pavel Stehule
Hi > > > > some times can be pretty ineffective to have database per customer - more > > connect, disconnect in postgres is much more expensive than SET > search_path > > TO .. and maybe RESET plans; > > I guess that means there is a practical application where search_path > MAY change at runtime