#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2012
    Posts
    3
    Rep Power
    0

    Multitenant: Best Practices?


    Hello,

    We are going to use PG as our database for an online, multitenant SaaS application. We want to place each subscriber in his/her own database. I am wondering whether there are any best practices for using PG in a multiuser, SaaS situation, where performance is crucial. For example, I have found references that each tenant should have their own tablespace (directory), but I have found other references where the tablespace should be assigned on a per application basis.

    We will most likely use the EnterpriseDB Amazon Web Services: "Postgres Plus Cloud Database". Has anyone used it for a scalable, SaaS application? The only unfortunate thing that I can find is that all of the users are assigned to the database instance rather than to each database...

    Anyway, I hope that we can get a good conversation going because I am sure that others will be asking for this information, too.

    Thank you for your time and suggestions,
    Mike
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2012
    Posts
    1
    Rep Power
    0
    hi,
    is your development completed?

IMN logo majestic logo threadwatch logo seochat tools logo