Re: Converting from single user w/pool to multiple users

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Converting from single user w/pool to multiple users
Дата
Msg-id 27136.1111679996@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Converting from single user w/pool to multiple users  (Jeff Amiel <jamiel@istreamimaging.com>)
Ответы Re: Converting from single user w/pool to multiple users  (Jeff Amiel <jamiel@istreamimaging.com>)
Re: Converting from single user w/pool to multiple users  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Jeff Amiel <jamiel@istreamimaging.com> writes:
> Anyone see any issues with having thousands of postgresql users
> established?  Are there any internal limits?

There's no hard limit.  Offhand the only thing I can think of that might
be a bit slow is password lookup during connection --- I think that does
a linear scan through a list of usernames.  This is only an issue if you
use passwords of course, but I suppose you probably would.  (It would
likely not be hard to improve the search algorithm, if it did become
a bottleneck.)

> Under the new scheme, we are limited by  max_connections
> (postgresql.conf)...and would return an error immediately when no
> connections were available.  Is there any way to mitigate this?

This is doubtless the worst problem...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Ricardo Fonseca e Campos"
Дата:
Сообщение: How to get the size in bytes of a table data
Следующее
От: Richard_D_Levine@raytheon.com
Дата:
Сообщение: Re: Good Books