Postgres Pro
Downloads
Home   >   mailing lists

Re: Implications of having large number of users - Mailing list pgsql-performance

From Albe Laurenz
Subject Re: Implications of having large number of users
Date
Msg-id D960CB61B694CF459DCFB4B0128514C202FF667D@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: Implications of having large number of users  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Implications of having large number of users  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Robert Haas wrote:
> > You cannot keep the connection and change users.
> > A change of database user always means a new connection and a new
> > backend process.
>
> I don't think this is true.  You can use SET SESSION AUTHORIZATION,
> right?

You are right, I overlooked that.
It is restricted to superusers though.

Yours,
Laurenz Albe

pgsql-performance by date:

Previous
From: "Dave North"
Date:
Subject: Nested Loop "Killer" on 8.1
Next
From: Tom Lane
Date:
Subject: Re: Implications of having large number of users