postgresql - Messaging system : One Postgre Database, several instances of the server -
i developing messaging scheme (in java) can back upwards around 10k users. architecture supposed next : - 10k clients - 2 or more replicas of server (each on different machine) - 1 postgre db
the application aimed run on clustered environment (amazone webservice).
now, have read couple of things on schemas in postgre db's. not sure if should utilize them (and in way) or if simple relational db model do.
basically, db supposed simple (messages/metadata, queueid messages, , users).
thank answers
don't bother schemas. useful semantically separating info in database lots of tables can grouped clusters relevant separate topics. don't help performance, clustering or replicating databases. also, agree frank heikens - unless each of users sends messages high frequency, wouldn't worry.
postgresql cluster-computing
No comments:
Post a Comment