On Fri, Feb 3, 2012 at 2:55 PM, Christopher Opena <counterv...@gmail.com> wrote: > Merlin, thanks for the response.
no problem. if you're open to architecture suggestions you might also want to consider going with HS/SR and getting those large olap queries off your main database. you'll have to configure it to be very forgiving of long running queries (which can pause replication) but this should be a huge win in terms of total load on the main server. also, you can skimp on hardware to a certain degree to cut costs. we still want to get to the bottom of this obviously but it can't hurt to get a plan 'B' going... merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
