On 10/6/06, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > On Fri, Oct 06, 2006 at 12:20:55PM -0700, snacktime wrote: > > > > Hardware is in the process of being upgraded. Will be on 2-4 way > > opteron systems most likely with raid. Right now we are looking > > closely at the sun amd stuff. 10-20 new accounts per day, 1-3 > > deletions. > > What I was more meaning was how much the users' data changes per day. > If you have 5000 users all doing 50 million updates a day, that's > going to be a problem along with the sequence stuff Chris talked > about. I'd prototype it for sure.
The database stores order/transaction information. Most of the activity is inserts, with some selects (web based reports on transactions), and infrequent updates. I have thought long and hard about just using one schema, but I really like the extra layers of separation that the schema provides. I kind of anticipated possible issues so all of our tables are designed to work fine in just one schema, and our queries are written as if the schema didn't exist except for prepending the schema name to every query. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
