Thread: The cost of SET search_path TO

Hi,

I will appreciate it if anyone can educate me on the cost of using SET
search_path TO for schemas at runtime. In particular, for .NET data
operations where there may be high rate of connection/disconnection and
reconnection for initial data fetching and subsequent updating.

Best regards


Tope Akinniyi
ShepherdHill Software
Lagos

> 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