X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 09E3230FEEC for ; Wed, 2 Jul 2003 12:45:17 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 51526-08 for ; Wed, 2 Jul 2003 09:45:06 -0300 (ADT) Received: from tomts14-srv.bellnexxia.net (tomts14.bellnexxia.net [209.226.175.35]) by svr1.postgresql.org (Postfix) with ESMTP id 80309310D3A for ; Wed, 2 Jul 2003 09:45:04 -0300 (ADT) Received: from [192.168.1.200] ([216.209.81.133]) by tomts14-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030702124503.UNVS23441.tomts14-srv.bellnexxia.net@[192.168.1.200]>; Wed, 2 Jul 2003 08:45:03 -0400 Subject: Re: How to optimize monstrous query, sorts instead of From: Rod Taylor To: michael.mattox@verideon.com Cc: Postgresql Performance In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-tT26ztHAzhPs8q6G2Gq/" Message-Id: <1057149922.28657.163.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.0 Date: 02 Jul 2003 12:45:23 +0000 X-Archive-Number: 200307/25 X-Sequence-Number: 2318 --=-tT26ztHAzhPs8q6G2Gq/ Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2003-07-02 at 10:28, Michael Mattox wrote: > > My postgresql.conf is attached in case I have it configured incorrectly. >=20 > Forgot my postgres.conf.. Shared buffers is probably too high. How much memory in this machine?=20 Is there anything else running aside from PostgreSQL? What does top say about cached / buffered data (number) I see you reduced the random_page_cost to 1.5. Why did you do this (how is your disk subsystem configured)? --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-tT26ztHAzhPs8q6G2Gq/ Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA/AtPi6DETLow6vwwRAsiWAJwLEyLgRI0SLYE6JZioxSL+y5gx9QCfSFK4 5lrT/S64ysAz/MRIHzYKvkA= =ee5y -----END PGP SIGNATURE----- --=-tT26ztHAzhPs8q6G2Gq/--