[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: [PERFORM] how can a couple of expensive queries drag my system down?
From: Erik Jones <erik () myemma ! com>
Date: 2008-03-27 15:13:37
Message-ID: A79F9B63-2EF3-442C-8145-8AFF89DBCF4C () myemma ! com
[Download RAW message or body]
On Mar 26, 2008, at 3:31 PM, Scott Marlowe wrote:
> 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.
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@myemma.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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic