Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DFFDD475FD5 for ; Thu, 16 Jan 2003 09:23:27 -0500 (EST) Received: from jester.senspire.com (CPE00508b028d7d-CM00803785c5e0.cpe.net.cable.rogers.com [24.103.51.175]) by postgresql.org (Postfix) with ESMTP id 31CCB475CEE for ; Thu, 16 Jan 2003 09:23:27 -0500 (EST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by jester.senspire.com (8.12.6/8.12.6) with ESMTP id h0GENXfe033690; Thu, 16 Jan 2003 09:23:33 -0500 (EST) (envelope-from rbt@rbt.ca) Subject: Re: 7.3.1 New install, large queries are slow From: Rod Taylor To: Roman Fail Cc: PgSQL Performance ML In-Reply-To: <1042720183.892.18.camel@haggis> References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C02@pos_pdc.posportal.com> <1042720183.892.18.camel@haggis> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-h6okXiXg4P76ZXXA2EZx" Organization: Message-Id: <1042727012.82534.50.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.0 Date: 16 Jan 2003 09:23:32 -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/145 X-Sequence-Number: 792 --=-h6okXiXg4P76ZXXA2EZx Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Thu, 2003-01-16 at 07:29, Ron Johnson wrote: > On Thu, 2003-01-16 at 03:03, Roman Fail wrote: > > *********************** > > > Josh Berkus wrote: > > > Hey, Roman, how many records in BatchDetail, anyway? > >=20 > > 23 million. >=20 > What are the indexes on batchdetail? >=20 > There's one on batchid and a seperate one on tranamount? >=20 > If so, what about dropping them and create a single multi-segment > index on "batchid, tranamount". (A constraint can then enforce > uniqueness on batchid. Thats a good step. Once done, CLUSTER by that index -- might buy 10 to 20% extra. --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-h6okXiXg4P76ZXXA2EZx Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) iD8DBQA+JsBj6DETLow6vwwRAgHAAJ9Uxj4BQ/tMQooJ0l7z0/PjV+EAhACfZT5U OR5Ig7+qxeprpC93ckBJX4s= =MKW8 -----END PGP SIGNATURE----- --=-h6okXiXg4P76ZXXA2EZx--