> Hi,
>
> I will appreciate it if anyone can educate me on the cost of
> using SET search_path TO for schemas at runtime.
AFAIK, that's quite cheap. Shouldn't be a problem.
> In
> particular, for .NET data operations where there may be high
> rate of connection/disconnection and reconnection for initial
> data fetching and subsequent updating.
You should be using connection pooling for this. I beleive npgsql
supports it just fine. That'll make a *lot* of difference on performance
in this kind of scenario.
//Magnus