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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
