I want to migrate a lot of single user databases onto a single server to allow the users to access them remotely, instead of on the workstations. The databases are quite small and even the most heavily used ones only have at most a few hundred records added to them everyday.
The problem is they have a high polling rate, about every 5 secs. If I migrate them to a central servers how much hardware will be needed for them to cope? My initial approach was to create views for each user and use updateable views and/or triggers so that the applications can work transparently simply by changing the names of the tables to the names of the views, but I am wondering whether it will be much simpler to use individual databases instead. /voipfc -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
