Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9C0932E0075 for ; Wed, 26 Mar 2008 17:31:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96626-02 for ; Wed, 26 Mar 2008 17:31:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rn-out-0910.google.com (rn-out-0910.google.com [64.233.170.186]) by postgresql.org (Postfix) with ESMTP id 753012E0049 for ; Wed, 26 Mar 2008 17:31:34 -0300 (ADT) Received: by rn-out-0910.google.com with SMTP id e11so2284232rng.17 for ; Wed, 26 Mar 2008 13:31:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=yicO46O0auIpzgTKlX9dHJ0Ffh56qR4aIXSUxSHo63k=; b=qJ+9M+u6uKSyYEJCs/GYdNx6e7KLG1txXgootkO0qazgvxI3F8h7xm2+IweOYOxPSABWABMbzla/2mI3/gFE8kePVZ/d2Rae6eaKVE/zezFf+Ekr6fbU2HYkzz/u+kVQvFSmpVTbofEUKoOlfmpLR3WMqBO73nwcNmfOV6RROjc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=MA9REdHlV9VZS8ja+JEU5pME6LS2jzpm2D2rG4kBvvzOId7kAwMNpGAINdPFTkUeLYgKZmpUhUXFgBi6vAszSkMldH3zoULOJ3+RgYw2IqqJ0jhhJa/obqLkauytYqHQjW6nLZXgvr4MIGIfcKHAZyZdZPyV2M4VxIRx3Fz6jBw= Received: by 10.142.191.2 with SMTP id o2mr715434wff.209.1206563492540; Wed, 26 Mar 2008 13:31:32 -0700 (PDT) Received: by 10.142.172.11 with HTTP; Wed, 26 Mar 2008 13:31:32 -0700 (PDT) Message-ID: Date: Wed, 26 Mar 2008 14:31:32 -0600 From: "Scott Marlowe" To: "p prince" Subject: Re: how can a couple of expensive queries drag my system down? Cc: pgsql-performance@postgresql.org In-Reply-To: <9722e78e0803261248g3305c2b9yfd5cfd528a505150@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <9722e78e0803261248g3305c2b9yfd5cfd528a505150@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/495 X-Sequence-Number: 29449 On Wed, Mar 26, 2008 at 1:48 PM, p prince 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.