On Wednesday 17 November 2010 11:58:33 Markus Wanner wrote:
> Andreas,
>
> On 11/17/2010 11:38 AM, Andres Freund wrote:
> > Well, one could optimize most of the resetting away if the the old
> > MyDatabaseId and the new one are the same - an optimization which is
> > hardly possible with forking new backends.
> Uh? Why not simply re-use the same backend, then? Or do you think of
> re-connecting to the same database as a way to reset your connection?
I am thinking of a connection-pooler like setup. Quite often your main-load
goes towards a single database - in that situation you don't have to reset the
database id most of the time.
Andres