Howdy, I find that user accounts are very good for helping me protect application access to the database. That is, instead of giving a user 1 account, I may give hem 10, and each of those accounts are restricted in the database in different ways. Anyway, I'm wondering what the maximum number of user accounts can be in a postgres database? Can I create a database with 1 million login roles and expect performance to be good? 10 million? Thanks, -g -- Greg Fausak greg@xxxxxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match