From: Scott Marlowe <scott.marlowe@gmail.com>
To: p prince <pprince127@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: how can a couple of expensive queries drag my system down?
Date: Wed, 26 Mar 2008 14:31:32 -0600
Message-ID: <dcc563d10803261331g6c35f964se6bce1720ebd8209@mail.gmail.com> (raw)
In-Reply-To: <9722e78e0803261248g3305c2b9yfd5cfd528a505150@mail.gmail.com>
References: <9722e78e0803261248g3305c2b9yfd5cfd528a505150@mail.gmail.com>
On Wed, Mar 26, 2008 at 1:48 PM, p prince <pprince127@gmail.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, pprince127@gmail.com
Subject: Re: how can a couple of expensive queries drag my system down?
In-Reply-To: <dcc563d10803261331g6c35f964se6bce1720ebd8209@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox