Re: how can a couple of expensive queries drag my system down?

[Erik Jones <erik(at)myemma(dot)com>]

On Mar 26, 2008, at 3:31 PM, Scott Marlowe wrote:
> On Wed, Mar 26, 2008 at 1:48 PM, p prince <pprince127(at)gmail(dot)com>  
> wrote:
> > is this 'normal'? (loaded question I know)
> > Should I be looking to offload expensive reporting queries to read- 
> > only
> > replicants of my database?
>
> Yes, definitely look into setting up something like a slony slave
> that's used for reporting queries.  The nice thing about this setup is
> you only need to replicate the tables you run reports against.

For simple two-node (i.e. no cascaded replication) I'd suggest looking  
into Londiste.  It's loads easier to wrap your head around and it's  
extremely easy to add/remove tables from replication as it doesn't  
deal with "table sets" like Slony does.

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com