Wed Oct 11 11:56:37 PDT 2006
- Previous message: [Slony1-general] drop cluster
- Next message: [Slony1-general] Using slony with many schema's
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
First, thanks for all the feedback. After spending some more time evaluating what we would gain by using slony I'm not sure it's worth it. However I thought I would get some more feedback before finalizing that decision. The primary reason for looking at replication was to move cpu intensive SELECT queries to a slave. However, by moving away from schema's the report queries for all clients on the server become more cpu intensive instead of just the clients with large data sets. The average distribution is that 95% of our clients have less then 5000 rows in any table, and the other 5% can have hundreds of thousands. 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. Chris
- Previous message: [Slony1-general] drop cluster
- Next message: [Slony1-general] Using slony with many schema's
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list