Re: authentication questions

"Michael Hanna" <zen(at)hwcn(dot)org> wrote:
> OK, but what if you have thousands of users in your pg_shadow table?
> Can postgreSQL handle such a load?

What change if instead you have thousand of user in your own table?
May be will be longer the identification process but not so longer then
have instead on user on that table.
BTW the table pg_shadow have an index on the column usename
and I believe that in the identification process you are asking if
the bottle-neck can be some think like:

select * from pg_shadow where usename = 'xxxxxxx';

I have a table that is similar to pg_shadow and the table handle
9823 rows, performing the query above take long 0.12 msec

I hope this help.

Regards
Gaetano Mendola