Jeff Amiel <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match