> 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend