Re: [GENERAL] [Slony1-general] Using slony with many schema's

2006-10-11 Thread Vivek Khera
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 amount

Re: [GENERAL] [Slony1-general] Using slony with many schema's

2006-10-11 Thread snacktime
Sorry wrong list, this was meant for the slony list... Chris ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] [Slony1-general] Using slony with many schema's

2006-10-11 Thread snacktime
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 S