Re: Controlling performance impact of multiple users
От | John Moore |
---|---|
Тема | Re: Controlling performance impact of multiple users |
Дата | |
Msg-id | 5.1.1.6.2.20020715121123.02944560@pop3.norton.antivirus обсуждение исходный текст |
Ответ на | Re: Controlling performance impact of multiple users (Curt Sampson <cjs@cynic.net>) |
Ответы |
Re: Controlling performance impact of multiple users
|
Список | pgsql-admin |
At 09:04 PM 7/14/2002, Curt Sampson wrote: >On Thu, 11 Jul 2002, John Moore wrote: > > > The issue is how to prevent users from hogging the system, and especially > > from slowing down the on-line users. > >Mixing OLTP and OLAP on one database server has never seemed like a good >idea to me. Part of the problem with the idea of resource limitation is >that if someone, say, starts a large update where it becomes apparent >that this is going to use too many resources only part-way into it, >you're kind of stuck. You have to either see it though, or pay the cost >of the rollback, which may be just as expensive by that point. I agree >Thus, I recommend somehow replicating the data from the OLTP server >to another server for the OLAP folks. This is how we did it at a previous employer. I was hoping somebody has some other trick, since we don't have any easy way to replicate the data! John
В списке pgsql-admin по дате отправления: