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. Thus, I recommend somehow replicating the data from the OLTP server to another server for the OLAP folks. cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
