Re: Implications of having large number of users

От: Albe Laurenz
Тема: Re: Implications of having large number of users
Дата: ,
Msg-id: D960CB61B694CF459DCFB4B0128514C202FF667D@exadv11.host.magwien.gv.at
(см: обсуждение, исходный текст)
Ответ на: Re: Implications of having large number of users  (Robert Haas)
Ответы: Re: Implications of having large number of users  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

Implications of having large number of users  (Mike Ivanov, )
 Re: Implications of having large number of users  ("Albe Laurenz", )
  Re: Implications of having large number of users  (Robert Haas, )
   Re: Implications of having large number of users  ("Albe Laurenz", )
    Re: Implications of having large number of users  (Tom Lane, )
     Re: Implications of having large number of users  (Robert Haas, )
 Re: Implications of having large number of users  (Mike Ivanov, )

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 по дате сообщения:

От: Scott Marlowe
Дата:
Сообщение: Re: cluster index on a table
От: Dimitri Fontaine
Дата:
Сообщение: Re: tsvector_update_trigger performance?