Postgres Pro
Downloads
Home   >   mailing lists

Maximum realistic number of database user accounts? - Mailing list pgsql-general

From Greg Fausak
Subject Maximum realistic number of database user accounts?
Date
Msg-id 8c7b802f0802140916r1b052875kebbe459adaa1c9ae@mail.gmail.com
Whole thread Raw
Responses Re: Maximum realistic number of database user accounts?  (Erik Jones <erik@myemma.com>)
Re: Maximum realistic number of database user accounts?  ("Christopher Browne" <cbbrowne@gmail.com>)
Re: Maximum realistic number of database user accounts?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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@thursday.com

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Order of SUBSTR and UPPER in statement
Next
From: Shane Ambler
Date:
Subject: Re: How to cope with low disk space