> 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
