On Oct 11, 2006, at 2:55 PM, snacktime wrote:
> So by putting all the data into one schema, every report query now
> gets run against a million or more rows instead of just a few hundred
> or thousand. So all clients will see a drop in query performance
> instead of just the clients with large amounts of data.
Indexes on the customer_id field of the combined data tables helps a
lot. That and big hardware with big RAM. :-)
We store data for all our customers in the same tables. some have
several hundred thousand of their own customers, and millions of
transactions from them; others have a few hundred. The
responsiveness of postgres is still great.