Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D7AE19FB32F for ; Fri, 3 Nov 2006 09:32:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49101-08 for ; Fri, 3 Nov 2006 09:32:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from heaven.kostyrka.org (h1634.serverkompetenz.net [81.169.154.44]) by postgresql.org (Postfix) with ESMTP id A73139FB326 for ; Fri, 3 Nov 2006 09:32:51 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by heaven.kostyrka.org (Postfix) with ESMTP id 4653E4FBE4; Fri, 3 Nov 2006 14:32:49 +0100 (CET) Received: from heaven.kostyrka.org ([127.0.0.1]) by localhost (heaven.kostyrka.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30025-02; Fri, 3 Nov 2006 14:32:49 +0100 (CET) Received: from [192.168.1.9] (85-124-81-107.dynamic.xdsl-line.inode.at [85.124.81.107]) by heaven.kostyrka.org (Postfix) with ESMTP id D1E364FB1C; Fri, 3 Nov 2006 14:32:48 +0100 (CET) Subject: Re: Setting "nice" values From: Andreas Kostyrka To: Scott Marlowe Cc: Madison Kelly , pgsql-performance@postgresql.org In-Reply-To: <1162482071.28047.39.camel@state.g2switchworks.com> References: <454A0B69.9070000@alteeve.com> <1162480836.28047.20.camel@state.g2switchworks.com> <454A0DD3.2050104@alteeve.com> <1162482071.28047.39.camel@state.g2switchworks.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-E5o1M/5fhVHnp7z69lvH" Date: Fri, 03 Nov 2006 14:34:24 +0100 Message-Id: <1162560864.16439.1.camel@andi-lap> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/42 X-Sequence-Number: 21812 --=-E5o1M/5fhVHnp7z69lvH Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Am Donnerstag, den 02.11.2006, 09:41 -0600 schrieb Scott Marlowe: > Sometimes it's the simple solutions that work best. :) Welcome to the > world of pgsql, btw... OTOH, there are also non-simple solutions to this, which might make sense anyway: Install slony, and run your queries against a readonly replica of your data. Andreas --=-E5o1M/5fhVHnp7z69lvH Content-Type: application/pgp-signature; name=signature.asc Content-Description: Dies ist ein digital signierter Nachrichtenteil -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQBFS0VgHJdudm4KnO0RAtpCAKCfc8QjsesVXYyjOI0wmKqawfkD+QCeMBTV I6OH12MV+Fw4AdDTfeXc1tc= =p3++ -----END PGP SIGNATURE----- --=-E5o1M/5fhVHnp7z69lvH--