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

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "p prince" <pprince127(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: how can a couple of expensive queries drag my system down?
Date: 2008-03-26 20:31:32
Message-ID: dcc563d10803261331g6c35f964se6bce1720ebd8209@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vinubalaji Gopal 2008-03-26 20:49:56 vacuum in Postgresql 8.0.x slowing down the database
Previous Message Alan Hodgson 2008-03-26 20:19:06 Re: how can a couple of expensive queries drag my system down?